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`, `stav`, `idAplikace`, `idAplikace2`, `idAplikaceKteraZpusobilaZmenu`, `puvodni_na_projektu_od`, `puvodni_na_projektu_do`) VALUES
(6750, 225, '36216', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'salkokat', '2022-11-01', '2038-12-30', '0.30', '6', 0, 7443, 2757, 0, 0, 10200, 10200, 13648, 13750, 34000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5460', '2', 'W-5485', '0000-00-00', '0000-00-00'),
(6763, 264, '36261', '312', '3122203V000', '1ND', 'NextPhage - TAČR TREND III - InoCure', 'divinrad', '2022-10-01', '2038-12-30', '0.66', '6', 0, 23100, 27060, 0, 0, 50160, 50160, 67114, 67616, 76000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5477', '1', 'W-5478', '0000-00-00', '0000-00-00'),
(6764, 245, '36261', '221', '2212201V000', '1ND', 'MVČR SECTECH NANOPACH', 'divinrad', '2022-10-01', '2038-12-30', '0.14', '6', 0, 4900, 5740, 0, 0, 10640, 10640, 14236, 14343, 76000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5477', '2', 'W-5478', '0000-00-00', '0000-00-00'),
(6765, 84, '36261', '312', '3122001V000', '1ND', 'TAČR ETA III - VVTO - Odorologie ', 'divinrad', '2022-10-01', '2038-12-30', '0.20', '6', 0, 7000, 8200, 0, 0, 15200, 15200, 20338, 20490, 76000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5477', '3', 'W-5478', '0000-00-00', '0000-00-00'),
(6837, 117, '36244', '302', '3022101V000', '1ND', 'GAČR - LEFM', 'matejsi2', '2022-10-01', '2023-12-31', '0.45', '5', 0, 10508, 8392, 0, 0, 18900, 18900, 25288, 25477, 42000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5508', '1', 'W-5550', '0000-00-00', '0000-00-00'),
(6844, 183, '36242', '552', '5522112V000', '1ND', 'OP PIK FASHEX / Dekmetal', 'prosezde', '2022-11-01', '2023-12-31', '0.40', '5', 0, 15600, 8400, 0, 0, 24000, 24000, 32112, 32352, 60000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5514', '1', 'W-5565', '0000-00-00', '0000-00-00'),
(6845, 177, '36221', '552', '5522108V000', '1ND', 'OP PIK ALTEKO Zmrhal', 'bartama2', '2022-11-01', '2023-12-31', '0.50', 'A3', 0, 15500, 9500, 0, 0, 25000, 25000, 33450, 33700, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5515', '1', 'W-5587', '0000-00-00', '0000-00-00'),
(6851, 189, '36221', '552', '5522109V000', '1ND', 'OP PIK QUANTUM', 'vavrirom', '2022-11-01', '2023-12-31', '0.35', 'A3', 0, 10850, 6650, 0, 0, 17500, 17500, 23415, 23590, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5519', '1', 'W-5753', '0000-00-00', '0000-00-00'),
(6852, 248, '36221', '552', '5522202V000', '1ND', 'OP PIK IX KARBOX II', 'vavrirom', '2022-11-01', '2023-12-31', '0.25', 'A3', 0, 7750, 4750, 0, 0, 12500, 12500, 16725, 16850, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5519', '2', 'W-5753', '0000-00-00', '0000-00-00'),
(6854, 112, '36221', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'zavrevoj', '2022-11-01', '2023-12-31', '0.50', 'A3', 0, 19500, 15500, 0, 0, 35000, 35000, 46830, 47180, 70000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5520', '1', 'W-5521', '0000-00-00', '0000-00-00'),
(6910, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'spickma2', '2022-11-01', '2023-12-31', '0.57', '4', 0, 12261, 10026, 0, 0, 22287, 22287, 29820, 30043, 39100, '', 'ne', 'ne', 'neni', 0, 1, 'W-5542', '1', 'W-5608', '0000-00-00', '0000-00-00'),
(6911, 182, '36930', '552', '5522111V000', '1ND', 'OP PIK ReTechSDOZero', 'spickma2', '2022-11-01', '2023-12-31', '0.43', '4', 0, 9250, 7563, 0, 0, 16813, 16813, 22496, 22664, 39100, '', 'ne', 'ne', 'B5', 42350, 1, 'W-5542', '2', 'W-5608', '0000-00-00', '0000-00-00'),
(6927, 341, '36215', '104', '1042218N000', '1ND', 'Kampus Dejvice PPRS 2022 - Vlasatá', 'koutsbar', '2022-11-01', '2038-12-30', '0.24', '6', 0, 5955, 2685, 0, 0, 8640, 8640, 11560, 11647, 36000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5557', '1', 'W-5561', '0000-00-00', '0000-00-00'),
(6928, 320, '36215', '301', '3012214A143', '1ND', 'Vícevrstvy GAČR - FSv Sněhota', 'koutsbar', '2022-11-01', '2038-12-30', '0.51', '6', 0, 12654, 5706, 0, 0, 18360, 18360, 24566, 24749, 36000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5557', '2', 'W-5561', '0000-00-00', '0000-00-00'),
(6980, 256, '36251', '552', '5522122V000', '1ND', 'OP PIK IX RoboPID', 'wawerrob', '2022-11-01', '2038-12-30', '0.20', '7', 0, 11000, 3400, 0, 1000, 15400, 14400, 20605, 20759, 72000, '', 'ne', 'ne', 'B1', 77000, 0, 'W-5580', '1', 'W-5598', '0000-00-00', '0000-00-00'),
(6981, 213, '36251', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'wawerrob', '2022-11-01', '2038-12-30', '0.25', '7', 0, 13750, 4250, 0, 1250, 19250, 18000, 25757, 25949, 72000, '', 'ne', 'ne', 'B1', 78856, 0, 'W-5580', '2', 'W-5598', '0000-00-00', '0000-00-00'),
(6982, 56, '36251', '313', '3131901V007', '1ND', 'NCK - RESOPT', 'wawerrob', '2022-11-01', '2038-12-30', '0.50', '7', 0, 27500, 8500, 0, 2500, 38500, 36000, 51513, 51898, 72000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5580', '3', 'W-5598', '0000-00-00', '0000-00-00'),
(6983, 208, '36251', '604', '6042201V000', '1ND', 'H2020 - ARV', 'wawerrob', '2022-11-01', '2038-12-30', '0.05', '7', 0, 2750, 850, 0, 250, 3850, 3600, 5151, 5190, 72000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5580', '4', 'W-5598', '0000-00-00', '0000-00-00'),
(6990, 84, '36261', '312', '3122001V000', '1ND', 'TAČR ETA III - VVTO - Odorologie ', 'amlerevz', '2022-01-01', '2022-02-28', '0.20', '7', 0, 10000, 7498, 0, 0, 17498, 17498, 23412, 23587, 87492, '', 'ne', 'ne', 'neni', 0, 1, 'W-5584', '1', 'W-5590', '0000-00-00', '0000-00-00'),
(6991, 245, '36261', '221', '2212201V000', '1ND', 'MVČR SECTECH NANOPACH', 'amlerevz', '2022-01-01', '2022-02-28', '0.10', '7', 0, 5000, 3749, 0, 0, 8749, 8749, 11706, 11794, 87492, '', 'ne', 'ne', 'neni', 0, 1, 'W-5584', '2', 'W-5590', '0000-00-00', '0000-00-00'),
(6992, 264, '36261', '312', '3122203V000', '1ND', 'NextPhage - TAČR TREND III - InoCure', 'amlerevz', '2022-01-01', '2022-02-28', '0.20', '7', 0, 10000, 7498, 0, 0, 17498, 17498, 23412, 23587, 87492, '', 'ne', 'ne', 'neni', 0, 1, 'W-5584', '3', 'W-5590', '0000-00-00', '0000-00-00'),
(6993, 264, '36261', '312', '3122203V000', '1ND', 'NextPhage - TAČR TREND III - InoCure', 'kraloma5', '2022-01-01', '2022-05-31', '0.35', '6', 0, 8684, 70, 0, 0, 8754, 8754, 11713, 11800, 25011, '', 'ne', 'ne', 'neni', 0, 1, 'W-5585', '1', 'W-5591', '0000-00-00', '0000-00-00'),
(6994, 84, '36261', '312', '3122001V000', '1ND', 'TAČR ETA III - VVTO - Odorologie ', 'kraloma5', '2022-01-01', '2022-05-31', '0.15', '6', 0, 3722, 30, 0, 0, 3752, 3752, 5020, 5058, 25011, '', 'ne', 'ne', 'neni', 0, 1, 'W-5585', '2', 'W-5591', '0000-00-00', '0000-00-00'),
(6995, 245, '36261', '221', '2212201V000', '1ND', 'MVČR SECTECH NANOPACH', 'novotp17', '2022-01-01', '2022-05-31', '0.20', '6', 0, 4962, 642, 0, 0, 5604, 5604, 7498, 7554, 28020, '', 'ne', 'ne', 'neni', 0, 1, 'W-5586', '1', 'W-5592', '0000-00-00', '0000-00-00'),
(6996, 84, '36261', '312', '3122001V000', '1ND', 'TAČR ETA III - VVTO - Odorologie ', 'novotp17', '2022-01-01', '2022-05-31', '0.40', '6', 0, 9924, 1284, 0, 0, 11208, 11208, 14996, 15108, 28020, '', 'ne', 'ne', 'neni', 0, 1, 'W-5586', '2', 'W-5592', '0000-00-00', '0000-00-00'),
(6997, 264, '36261', '312', '3122203V000', '1ND', 'NextPhage - TAČR TREND III - InoCure', 'novotp17', '2022-01-01', '2022-05-31', '0.40', '6', 0, 9924, 1284, 0, 0, 11208, 11208, 14996, 15108, 28020, '', 'ne', 'ne', 'neni', 0, 1, 'W-5586', '3', 'W-5592', '0000-00-00', '0000-00-00'),
(6999, 177, '36221', '552', '5522108V000', '1ND', 'OP PIK ALTEKO Zmrhal', 'zmrhavla', '2022-10-01', '2038-12-30', '0.15', 'A4', 0, 5688, 4812, 0, 0, 10500, 10500, 14049, 14154, 70000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5588', '1', 'W-5751', '0000-00-00', '0000-00-00'),
(7007, 254, '36255', '552', '5522124V000', '1ND', 'OP PIK IX EXPECT-IT II', 'belchwoj', '2023-01-01', '2038-12-30', '1.00', '6', 0, 30000, 25000, 5000, 0, 60000, 55000, 80280, 80880, 55000, '', 'ne', 'ne', 'B2', 66000, 1, 'W-5599', '1', 'W-5842', '0000-00-00', '0000-00-00'),
(7014, 167, '36255', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'stanknic', '2023-01-01', '2038-12-30', '0.10', '6', 0, 2481, 2219, 0, 0, 4700, 4700, 6289, 6336, 47000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5600', '1', 'W-5881', '0000-00-00', '0000-00-00'),
(7015, 270, '36255', '311', '3112207V000', '1ND', 'TAČR BETA - Energetické komunity - Vácha', 'stanknic', '2023-01-01', '2038-12-30', '0.30', '6', 0, 7444, 6656, 0, 0, 14100, 14100, 18866, 19007, 47000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5600', '2', 'W-5881', '0000-00-00', '0000-00-00'),
(7016, 208, '36255', '604', '6042201V000', '1ND', 'H2020 - ARV', 'stanknic', '2023-01-01', '2038-12-30', '0.05', '6', 0, 1241, 1109, 0, 0, 2350, 2350, 3144, 3168, 47000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5600', '4', 'W-5881', '0000-00-00', '0000-00-00'),
(7017, 75, '36255', '604', '6041901V000', '1ND', 'H2020 - SPARCS', 'stanknic', '2023-01-01', '2038-12-30', '0.05', '6', 0, 1241, 1109, 0, 0, 2350, 2350, 3144, 3168, 47000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5600', '5', 'W-5881', '0000-00-00', '0000-00-00'),
(7098, 195, '', '552', '5522106V000', '1ND', 'OP PIK MOB-Bars FSv', 'XXXtmpXXXsedlasim', '2022-12-01', '2023-05-31', '0.18', '5', 0, 7171, 1792, 0, 0, 8963, 8963, 11992, 12082, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5647', '1', 'W-5779', '0000-00-00', '0000-00-00'),
(7103, 332, '', '604', '6042201A133', '1ND', 'Probono H2020 - Tencar', 'salkokat', '2022-12-01', '2022-12-31', '0.03', '6', 0, 744, 576, 0, 0, 1320, 1320, 1766, 1779, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5654', '1', 'W-5778', '2022-12-01', '2038-12-30'),
(7104, 225, '', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'salkokat', '2022-12-01', '2022-12-31', '0.20', '6', 0, 4962, 3838, 0, 0, 8800, 8800, 11774, 11862, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5654', '2', 'W-5778', '2022-12-01', '2038-12-30'),
(7105, 305, '', '661', '6612201V000', '1ND', 'Šance pro budovy ECF - Vlasatá', 'salkokat', '2022-12-01', '2022-12-31', '0.10', '6', 0, 2481, 1919, 0, 0, 4400, 4400, 5887, 5931, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5654', '3', 'W-5778', '2022-12-01', '2038-12-30'),
(7106, 277, '', '113', '1132210V000', '1ND', 'UNILEAD MŠMT - CRP 2022', 'salkokat', '2022-12-01', '2022-12-31', '0.07', '6', 0, 1737, 1343, 0, 0, 3080, 3080, 4121, 4152, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5654', '4', 'W-5778', '2022-12-01', '2038-12-30'),
(7107, 231, '', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'mascujak', '2022-12-01', '2038-12-30', '0.10', 'A3', 0, 3100, 3396, 0, 625, 7121, 6496, 9528, 9599, 64960, '', 'ne', 'ne', 'neni', 0, 1, 'W-5658', '1', 'W-5774', '0000-00-00', '0000-00-00'),
(7108, 90, '', '312', '3122002V000', '1ND', 'TAČR THETA III Data4energy', 'mascujak', '2022-12-01', '2038-12-30', '0.10', 'A3', 0, 3100, 3396, 0, 1125, 7621, 6496, 10197, 10273, 64960, '', 'ne', 'ne', 'neni', 0, 1, 'W-5658', '2', 'W-5774', '0000-00-00', '0000-00-00'),
(7109, 93, '', '552', '5522002V000', '1ND', 'OP PIK Kotel GTP', 'mascujak', '2022-12-01', '2038-12-30', '0.40', 'A3', 0, 12400, 13584, 0, 2000, 27984, 25984, 37443, 37722, 64960, '', 'ne', 'ne', 'neni', 0, 1, 'W-5658', '3', 'W-5774', '0000-00-00', '0000-00-00'),
(7110, 149, '', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'mascujak', '2022-12-01', '2038-12-30', '0.20', 'A3', 0, 6200, 6792, 0, 1250, 14242, 12992, 19056, 19198, 64960, '', 'ne', 'ne', 'neni', 0, 1, 'W-5658', '5', 'W-5774', '0000-00-00', '0000-00-00'),
(7111, 117, '', '302', '3022101V000', '1ND', 'GAČR - LEFM', 'stoladan', '2022-12-01', '2022-12-31', '0.12', '6', 0, 2977, 2303, 0, 0, 5280, 5280, 7065, 7117, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5659', '1', 'W-5780', '2022-12-01', '2038-12-30'),
(7112, 167, '', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'stoladan', '2022-12-01', '2022-12-31', '0.05', '6', 0, 1240, 960, 0, 0, 2200, 2200, 2944, 2966, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5659', '2', 'W-5780', '2022-12-01', '2038-12-30'),
(7113, 213, '', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'stoladan', '2022-12-01', '2022-12-31', '0.12', '6', 0, 2977, 2303, 0, 0, 5280, 5280, 7065, 7117, 44000, '', 'ne', 'ne', 'B7', 47300, 1, 'W-5659', '3', 'W-5780', '2022-12-01', '2038-12-30'),
(7114, 93, '', '552', '5522002V000', '1ND', 'OP PIK Kotel GTP', 'stoladan', '2022-12-01', '2022-12-31', '0.17', '6', 0, 4217, 3263, 0, 0, 7480, 7480, 10008, 10083, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5659', '4', 'W-5780', '2022-12-01', '2038-12-30'),
(7115, 47, '', '165', '1651901V000', '1ND', 'MŠMT INTER TRANSFER Annex 72 - životní cyklus budov', 'stoladan', '2022-12-01', '2022-12-31', '0.01', '6', 0, 248, 192, 0, 0, 440, 440, 589, 593, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5659', '5', 'W-5780', '2022-12-01', '2038-12-30'),
(7116, 189, '', '552', '5522109V000', '1ND', 'OP PIK QUANTUM', 'stoladan', '2022-12-01', '2022-12-31', '0.10', '6', 0, 2481, 1919, 0, 0, 4400, 4400, 5887, 5931, 44000, '', 'ne', 'ne', 'B7', 47300, 1, 'W-5659', '6', 'W-5780', '2022-12-01', '2038-12-30'),
(7117, 129, '', '312', '3122003V000', '1ND', 'TAČR TREND II - FullSpectraSun (Spectrasol)', 'stoladan', '2022-12-01', '2022-12-31', '0.08', '6', 0, 1985, 1535, 0, 0, 3520, 3520, 4710, 4745, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5659', '7', 'W-5780', '2022-12-01', '2038-12-30'),
(7118, 91, '', '888', '8889701V000', '9NN', 'Režie - ostatní', 'stoladan', '2022-12-01', '2022-12-31', '0.35', '6', 0, 8683, 6717, 0, 0, 15400, 15400, 20605, 20759, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5659', '8', 'W-5780', '2022-12-01', '2038-12-30'),
(7119, 81, '', '165', '1652001V000', '1ND', 'MŠMT INTER ACTION INDIE', 'reistkri', '2022-12-01', '2038-12-30', '0.10', '6', 0, 2481, 1919, 0, 0, 4400, 4400, 5887, 5931, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5660', '1', 'W-5682', '0000-00-00', '0000-00-00'),
(7120, 256, '', '552', '5522122V000', '1ND', 'OP PIK IX RoboPID', 'reistkri', '2022-12-01', '2038-12-30', '0.40', '6', 0, 9924, 7676, 0, 0, 17600, 17600, 23549, 23725, 44000, '', 'ne', 'ne', 'B4', 49500, 1, 'W-5660', '2', 'W-5682', '0000-00-00', '0000-00-00'),
(7121, 91, '', '888', '8889701V000', '9NN', 'Režie - ostatní', 'reistkri', '2022-12-01', '2038-12-30', '0.10', '6', 0, 2481, 1919, 0, 0, 4400, 4400, 5887, 5931, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5660', '3', 'W-5682', '0000-00-00', '0000-00-00'),
(7122, 128, '', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'reistkri', '2022-12-01', '2038-12-30', '0.25', '6', 0, 6203, 4798, 0, 0, 11000, 11000, 14718, 14828, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5660', '4', 'W-5682', '0000-00-00', '0000-00-00'),
(7123, 243, '', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'reistkri', '2022-12-01', '2038-12-30', '0.15', '6', 0, 3722, 2879, 0, 0, 6600, 6600, 8831, 8897, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5660', '5', 'W-5682', '0000-00-00', '0000-00-00'),
(7134, 213, '36920', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'holecste', '2023-01-01', '2038-12-30', '0.94', '6', 0, 23321, 20013, 0, 0, 43334, 43334, 57981, 58414, 46100, '', 'ne', 'ne', 'B7', 47300, 1, 'W-5666', '1', 'W-5902', '0000-00-00', '0000-00-00'),
(7135, 270, '36920', '311', '3112207V000', '1ND', 'TAČR BETA - Energetické komunity - Vácha', 'holecste', '2023-01-01', '2038-12-30', '0.06', '6', 0, 1489, 1277, 0, 0, 2766, 2766, 3701, 3729, 46100, '', 'ne', 'ne', 'neni', 0, 1, 'W-5666', '2', 'W-5902', '0000-00-00', '0000-00-00'),
(7154, 213, '36940', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'kuklipe1', '2023-01-01', '2038-12-30', '0.50', '6', 0, 17000, 14500, 0, 0, 31500, 31500, 42147, 42462, 63000, '', 'ne', 'ne', 'B4', 71500, 1, 'W-5671', '1', 'W-5903', '0000-00-00', '0000-00-00'),
(7160, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'simanm11', '2022-12-01', '2022-12-31', '0.05', '4', 0, 1076, 1174, 0, 0, 2250, 2250, 3011, 3033, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5673', '1', 'W-5959', '2022-12-01', '2038-12-30'),
(7161, 255, '36222', '552', '5522201V000', '1ND', 'OP PIK IX MiniBio', 'simanm11', '2022-12-01', '2022-12-31', '0.80', '4', 0, 17216, 18784, 0, 0, 36000, 36000, 48168, 48528, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5673', '2', 'W-5959', '2022-12-01', '2038-12-30'),
(7162, 230, '36222', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'simanm11', '2022-12-01', '2022-12-31', '0.05', '4', 0, 1076, 1174, 0, 0, 2250, 2250, 3011, 3033, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5673', '3', 'W-5959', '2022-12-01', '2038-12-30'),
(7163, 232, '36222', '311', '3112203V000', '1ND', 'TAČR THETA IV - tribo-RVE (Šlechta)', 'simanm11', '2022-12-01', '2022-12-31', '0.05', '4', 0, 1076, 1174, 0, 0, 2250, 2250, 3011, 3033, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5673', '4', 'W-5959', '2022-12-01', '2038-12-30'),
(7164, 231, '36222', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'simanm11', '2022-12-01', '2022-12-31', '0.05', '4', 0, 1076, 1174, 0, 0, 2250, 2250, 3011, 3033, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5673', '5', 'W-5959', '2022-12-01', '2038-12-30'),
(7175, 183, '36870', '552', '5522112V000', '1ND', 'OP PIK FASHEX / Dekmetal', 'machdavi', '2023-01-01', '2038-12-30', '0.33', '5', 0, 10335, 8475, 0, 0, 18810, 18810, 25168, 25356, 57000, '', 'ne', 'ne', 'B4', 57000, 1, 'W-5675', '1', 'W-5910', '0000-00-00', '0000-00-00'),
(7176, 197, '36870', '552', '5522110V000', '1ND', 'OP PIK Multi-Heat / TECHTRANS', 'machdavi', '2023-01-01', '2038-12-30', '0.18', '5', 0, 5440, 4460, 0, 0, 9900, 9900, 13246, 13345, 55000, '', 'ne', 'ne', 'B5', 55000, 1, 'W-5675', '2', 'W-5910', '0000-00-00', '0000-00-00'),
(7177, 191, '36870', '552', '5522114V000', '1ND', 'OP PIK Senzor viskozity', 'machdavi', '2023-01-01', '2038-12-30', '0.10', '5', 0, 3000, 2460, 0, 0, 5460, 5460, 7305, 7360, 54600, '', 'ne', 'ne', 'B4', 54600, 1, 'W-5675', '3', 'W-5910', '0000-00-00', '0000-00-00'),
(7178, 256, '36870', '552', '5522122V000', '1ND', 'OP PIK IX RoboPID', 'machdavi', '2023-01-01', '2038-12-30', '0.39', '5', 0, 12764, 10466, 0, 0, 23230, 23230, 31082, 31314, 59564, '', 'ne', 'ne', 'B5', 60500, 1, 'W-5675', '4', 'W-5910', '0000-00-00', '0000-00-00'),
(7179, 252, '36950', '552', '5522123V000', '1ND', 'OP PIK IX Softlink II', 'noskoson', '2023-01-01', '2038-12-30', '0.23', '6', 0, 5706, 3816, 0, 0, 9522, 9522, 12740, 12836, 41400, '', 'ne', 'ne', 'B6', 47300, 1, 'W-5676', '1', 'W-5907', '0000-00-00', '0000-00-00'),
(7180, 213, '36950', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'noskoson', '2023-01-01', '2038-12-30', '0.50', '6', 0, 12404, 8296, 0, 0, 20700, 20700, 27697, 27904, 41400, '', 'ne', 'ne', 'B7', 47300, 1, 'W-5676', '2', 'W-5907', '0000-00-00', '0000-00-00'),
(7181, 179, '36950', '552', '5522103V000', '1ND', 'OP PIK Energocentrum II SCADA BI', 'noskoson', '2023-01-01', '2038-12-30', '0.27', '6', 0, 6698, 4480, 0, 0, 11178, 11178, 14956, 15068, 41400, '', 'ne', 'ne', 'B7', 50600, 1, 'W-5676', '3', 'W-5907', '0000-00-00', '0000-00-00'),
(7184, 128, '36910', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'lupisant', '2023-01-01', '2038-12-30', '0.19', 'A3', 0, 13843, 8641, 0, 0, 22484, 22484, 30084, 30308, 118335, '', 'ne', 'ne', 'neni', 0, 1, 'W-5678', '1', 'W-5898', '0000-00-00', '0000-00-00'),
(7185, 208, '36910', '604', '6042201V000', '1ND', 'H2020 - ARV', 'lupisant', '2023-01-01', '2038-12-30', '0.40', 'A3', 0, 29143, 18191, 0, 0, 47334, 47334, 63333, 63806, 118335, '', 'ne', 'ne', 'neni', 0, 1, 'W-5678', '2', 'W-5898', '0000-00-00', '0000-00-00'),
(7186, 91, '36910', '888', '8889701V000', '9NN', 'Režie - ostatní', 'lupisant', '2023-01-01', '2038-12-30', '0.21', 'A3', 0, 15300, 9550, 0, 0, 24850, 24850, 33249, 33498, 118335, '', 'ne', 'ne', 'neni', 0, 1, 'W-5678', '3', 'W-5898', '0000-00-00', '0000-00-00'),
(7197, 213, '36930', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'pospika4', '2023-01-01', '2038-12-30', '0.12', '6', 0, 2978, 2566, 0, 0, 5544, 5544, 7418, 7473, 46200, '', 'ne', 'ne', 'B7', 47300, 1, 'W-5681', '1', 'W-5901', '0000-00-00', '0000-00-00'),
(7198, 191, '36930', '552', '5522114V000', '1ND', 'OP PIK Senzor viskozity', 'pospika4', '2023-01-01', '2038-12-30', '0.23', '6', 0, 5708, 4918, 0, 0, 10626, 10626, 14218, 14324, 46200, '', 'ne', 'ne', 'B4', 54600, 1, 'W-5681', '2', 'W-5901', '0000-00-00', '0000-00-00'),
(7199, 180, '36930', '552', '5522105V000', '1ND', 'OP PIK LASSO', 'pospika4', '2023-01-01', '2038-12-30', '0.13', '6', 0, 3226, 2780, 0, 0, 6006, 6006, 8036, 8096, 46200, '', 'ne', 'ne', 'B8', 46200, 1, 'W-5681', '3', 'W-5901', '0000-00-00', '0000-00-00'),
(7200, 187, '36930', '552', '5522107V000', '1ND', 'OP PIK DH4.ENERGY / Feramat', 'pospika4', '2023-01-01', '2038-12-30', '0.23', '6', 0, 5708, 4918, 0, 0, 10626, 10626, 14218, 14324, 46200, '', 'ne', 'ne', 'B5', 51000, 1, 'W-5681', '4', 'W-5901', '0000-00-00', '0000-00-00'),
(7201, 231, '36930', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'pospika4', '2023-01-01', '2038-12-30', '0.14', '6', 0, 3474, 2994, 0, 0, 6468, 6468, 8654, 8719, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5681', '5', 'W-5901', '0000-00-00', '0000-00-00'),
(7202, 255, '36930', '552', '5522201V000', '1ND', 'OP PIK IX MiniBio', 'pospika4', '2023-01-01', '2038-12-30', '0.15', '6', 0, 3723, 3208, 0, 0, 6930, 6930, 9272, 9342, 46200, '', 'ne', 'ne', 'B5', 49060, 1, 'W-5681', '6', 'W-5901', '0000-00-00', '0000-00-00'),
(7208, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'reistkri', '2023-01-01', '2038-12-30', '0.20', '6', 0, 4962, 4278, 0, 0, 9240, 9240, 12363, 12456, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5683', '1', 'W-5900', '0000-00-00', '0000-00-00'),
(7209, 256, '36920', '552', '5522122V000', '1ND', 'OP PIK IX RoboPID', 'reistkri', '2023-01-01', '2038-12-30', '0.40', '6', 0, 9924, 8556, 0, 0, 18480, 18480, 24726, 24911, 46200, '', 'ne', 'ne', 'B4', 49500, 1, 'W-5683', '2', 'W-5900', '0000-00-00', '0000-00-00'),
(7210, 128, '36920', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'reistkri', '2023-01-01', '2038-12-30', '0.25', '6', 0, 6203, 5347, 0, 0, 11550, 11550, 15454, 15569, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5683', '3', 'W-5900', '0000-00-00', '0000-00-00'),
(7211, 243, '36920', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'reistkri', '2023-01-01', '2038-12-30', '0.15', '6', 0, 3722, 3208, 0, 0, 6930, 6930, 9272, 9342, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5683', '4', 'W-5900', '0000-00-00', '0000-00-00'),
(7212, 213, '36920', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'rutovmar', '2023-01-01', '2023-12-31', '1.00', '6', 0, 24810, 17190, 0, 0, 42000, 42000, 56196, 56616, 42000, '', 'ne', 'ne', 'B7', 47300, 1, 'W-5684', '1', 'W-5909', '0000-00-00', '0000-00-00'),
(7214, 213, '36910', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'seibejan', '2023-01-01', '2023-12-31', '1.00', '6', 0, 35000, 33300, 0, 0, 68300, 68300, 91385, 92068, 68300, '', 'ne', 'ano', 'B4', 71500, 0, 'W-5685', '1', 'W-5748', '0000-00-00', '0000-00-00'),
(7216, 213, '36950', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'simcijan', '2023-01-01', '2038-12-30', '1.00', '6', 0, 30000, 21500, 0, 0, 51500, 51500, 68907, 69422, 51500, '', 'ne', 'ano', 'B4', 71500, 1, 'W-5686', '1', 'W-5904', '0000-00-00', '0000-00-00'),
(7219, 117, '36920', '302', '3022101V000', '1ND', 'GAČR - LEFM', 'stoladan', '2023-01-01', '2038-12-30', '0.12', '6', 0, 2977, 2303, 0, 0, 5280, 5280, 7065, 7117, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5688', '1', 'W-5689', '0000-00-00', '0000-00-00'),
(7220, 167, '36920', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'stoladan', '2023-01-01', '2038-12-30', '0.05', '6', 0, 1240, 960, 0, 0, 2200, 2200, 2944, 2966, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5688', '2', 'W-5689', '0000-00-00', '0000-00-00'),
(7221, 213, '36920', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'stoladan', '2023-01-01', '2038-12-30', '0.12', '6', 0, 2977, 2303, 0, 0, 5280, 5280, 7065, 7117, 44000, '', 'ne', 'ne', 'B7', 47300, 1, 'W-5688', '3', 'W-5689', '0000-00-00', '0000-00-00'),
(7222, 93, '36920', '552', '5522002V000', '1ND', 'OP PIK Kotel GTP', 'stoladan', '2023-01-01', '2038-12-30', '0.17', '6', 0, 4217, 3263, 0, 0, 7480, 7480, 10008, 10083, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5688', '4', 'W-5689', '0000-00-00', '0000-00-00'),
(7223, 47, '36920', '165', '1651901V000', '1ND', 'MŠMT INTER TRANSFER Annex 72 - životní cyklus budov', 'stoladan', '2023-01-01', '2038-12-30', '0.01', '6', 0, 248, 192, 0, 0, 440, 440, 589, 593, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5688', '5', 'W-5689', '0000-00-00', '0000-00-00'),
(7224, 189, '36920', '552', '5522109V000', '1ND', 'OP PIK QUANTUM', 'stoladan', '2023-01-01', '2038-12-30', '0.10', '6', 0, 2481, 1919, 0, 0, 4400, 4400, 5887, 5931, 44000, '', 'ne', 'ne', 'B7', 47300, 1, 'W-5688', '6', 'W-5689', '0000-00-00', '0000-00-00'),
(7225, 129, '36920', '312', '3122003V000', '1ND', 'TAČR TREND II - FullSpectraSun (Spectrasol)', 'stoladan', '2023-01-01', '2038-12-30', '0.08', '6', 0, 1985, 1535, 0, 0, 3520, 3520, 4710, 4745, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5688', '7', 'W-5689', '0000-00-00', '0000-00-00'),
(7226, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'stoladan', '2023-01-01', '2038-12-30', '0.35', '6', 0, 8683, 6717, 0, 0, 15400, 15400, 20605, 20759, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5688', '8', 'W-5689', '0000-00-00', '0000-00-00'),
(7236, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'tomeska1', '2023-01-01', '2038-12-30', '0.25', '6', 0, 10000, 9075, 0, 500, 19575, 19075, 26191, 26387, 76300, '', 'ne', 'ne', 'neni', 0, 1, 'W-5692', '1', 'W-5905', '0000-00-00', '0000-00-00'),
(7237, 112, '36920', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'tomeska1', '2023-01-01', '2038-12-30', '0.05', '6', 0, 2000, 1815, 0, 100, 3915, 3815, 5238, 5277, 76300, '', 'ne', 'ne', 'neni', 0, 1, 'W-5692', '2', 'W-5905', '0000-00-00', '0000-00-00'),
(7238, 213, '36920', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'tomeska1', '2023-01-01', '2038-12-30', '0.70', '6', 0, 28000, 20510, 0, 1400, 49910, 48510, 66780, 67279, 69300, '', 'ne', 'ne', 'B5', 69300, 1, 'W-5692', '4', 'W-5905', '0000-00-00', '0000-00-00'),
(7245, 117, '36920', '302', '3022101V000', '1ND', 'GAČR - LEFM', 'stoladan', '2023-01-01', '2038-12-30', '0.12', '6', 0, 3126, 2418, 0, 0, 5544, 5544, 7418, 7473, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5689', '1', 'W-5936', '0000-00-00', '0000-00-00'),
(7246, 167, '36920', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'stoladan', '2023-01-01', '2038-12-30', '0.05', '6', 0, 1302, 1008, 0, 0, 2310, 2310, 3091, 3114, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5689', '2', 'W-5936', '0000-00-00', '0000-00-00'),
(7247, 213, '36920', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'stoladan', '2023-01-01', '2038-12-30', '0.12', '6', 0, 3126, 2418, 0, 0, 5544, 5544, 7418, 7473, 46200, '', 'ne', 'ne', 'B7', 47300, 1, 'W-5689', '3', 'W-5936', '0000-00-00', '0000-00-00'),
(7248, 189, '36920', '552', '5522109V000', '1ND', 'OP PIK QUANTUM', 'stoladan', '2023-01-01', '2038-12-30', '0.10', '6', 0, 2605, 2015, 0, 0, 4620, 4620, 6182, 6228, 46200, '', 'ne', 'ne', 'B7', 47300, 1, 'W-5689', '6', 'W-5936', '0000-00-00', '0000-00-00'),
(7249, 129, '36920', '312', '3122003V000', '1ND', 'TAČR TREND II - FullSpectraSun (Spectrasol)', 'stoladan', '2023-01-01', '2038-12-30', '0.08', '6', 0, 2084, 1612, 0, 0, 3696, 3696, 4945, 4982, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5689', '7', 'W-5936', '0000-00-00', '0000-00-00'),
(7250, 279, '36920', '661', '6612202V000', '1ND', 'Cir4ConClimate EUKI - Pavlů', 'stoladan', '2023-01-01', '2038-12-30', '0.53', '6', 0, 13806, 10680, 0, 0, 24486, 24486, 32762, 33007, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5689', '8', 'W-5936', '0000-00-00', '0000-00-00'),
(7262, 74, '36216', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'vlasabar', '2022-12-01', '2038-12-30', '0.01', '6', 0, 250, 250, 0, 0, 500, 500, 669, 674, 50000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5697', '1', 'W-5700', '0000-00-00', '0000-00-00'),
(7263, 47, '36216', '165', '1651901V000', '1ND', 'MŠMT INTER TRANSFER Annex 72 - životní cyklus budov', 'vlasabar', '2022-12-01', '2038-12-30', '0.01', '6', 0, 250, 250, 0, 0, 500, 500, 669, 674, 50000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5697', '2', 'W-5700', '0000-00-00', '0000-00-00'),
(7264, 305, '36216', '661', '6612201V000', '1ND', 'Šance pro budovy ECF - Vlasatá', 'vlasabar', '2022-12-01', '2038-12-30', '0.01', '6', 0, 250, 250, 0, 0, 500, 500, 669, 674, 50000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5697', '3', 'W-5700', '0000-00-00', '0000-00-00'),
(7265, 277, '36216', '113', '1132210V000', '1ND', 'UNILEAD MŠMT - CRP 2022', 'vlasabar', '2022-12-01', '2038-12-30', '0.75', '6', 0, 18750, 18750, 0, 0, 37500, 37500, 50175, 50550, 50000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5697', '4', 'W-5700', '0000-00-00', '0000-00-00'),
(7266, 279, '36216', '661', '6612202V000', '1ND', 'Cir4ConClimate EUKI - Pavlů', 'vlasabar', '2022-12-01', '2038-12-30', '0.22', '6', 0, 5500, 5500, 0, 0, 11000, 11000, 14718, 14828, 50000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5697', '5', 'W-5700', '0000-00-00', '0000-00-00'),
(7267, 213, '36940', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'virabohd', '2023-01-01', '2038-12-30', '0.64', '6', 0, 22400, 16640, 0, 0, 39040, 39040, 52236, 52626, 61000, '', 'ne', 'ano', 'B5', 69300, 1, 'W-5696', '1', 'W-5899', '0000-00-00', '0000-00-00'),
(7268, 243, '36940', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'virabohd', '2023-01-01', '2038-12-30', '0.16', '6', 0, 5600, 4160, 0, 0, 9760, 9760, 13059, 13156, 61000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5696', '3', 'W-5899', '0000-00-00', '0000-00-00'),
(7274, 91, '36910', '888', '8889701V000', '9NN', 'Režie - ostatní', 'jararobe', '2023-01-01', '2038-12-30', '0.40', 'A3', 0, 22000, 22000, 0, 9000, 53000, 44000, 70914, 71444, 110000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5699', '1', 'W-5906', '0000-00-00', '0000-00-00'),
(7275, 250, '36910', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'jararobe', '2023-01-01', '2038-12-30', '0.40', 'A3', 0, 22000, 22000, 0, 9000, 53000, 44000, 70914, 71444, 110000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5699', '2', 'W-5906', '0000-00-00', '0000-00-00'),
(7316, 199, '36216', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'tencajir', '2023-01-01', '2038-12-30', '0.10', '7', 0, 3500, 2700, 0, 0, 6200, 6200, 8296, 8358, 62000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5715', '1', 'W-5876', '0000-00-00', '0000-00-00'),
(7317, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'hodkojul', '2023-01-01', '2023-12-31', '0.01', '7', 0, 277, 353, 0, 0, 630, 630, 843, 849, 63000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5713', '1', 'W-5784', '0000-00-00', '0000-00-00'),
(7318, 74, '36216', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'hodkojul', '2023-01-01', '2023-12-31', '0.37', '7', 0, 10249, 13061, 0, 0, 23310, 23310, 31189, 31422, 63000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5713', '2', 'W-5784', '0000-00-00', '0000-00-00'),
(7319, 47, '36216', '165', '1651901V000', '1ND', 'MŠMT INTER TRANSFER Annex 72 - životní cyklus budov', 'hodkojul', '2023-01-01', '2023-12-31', '0.01', '7', 0, 277, 353, 0, 0, 630, 630, 843, 849, 63000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5713', '3', 'W-5784', '0000-00-00', '0000-00-00'),
(7320, 305, '36216', '661', '6612201V000', '1ND', 'Šance pro budovy ECF - Vlasatá', 'hodkojul', '2023-01-01', '2023-12-31', '0.01', '7', 0, 277, 353, 0, 0, 630, 630, 843, 849, 63000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5713', '4', 'W-5784', '0000-00-00', '0000-00-00'),
(7321, 225, '36216', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'hodkojul', '2023-01-01', '2023-12-31', '0.60', '7', 0, 16620, 21180, 0, 0, 37800, 37800, 50576, 50954, 63000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5713', '5', 'W-5784', '0000-00-00', '0000-00-00'),
(7322, 167, '36216', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'sykorma6', '2023-01-01', '2038-12-30', '0.30', '6', 0, 7443, 6162, 0, 0, 13605, 13605, 18203, 18340, 45350, '', 'ne', 'ne', 'neni', 0, 1, 'W-5716', '1', 'W-5875', '0000-00-00', '0000-00-00'),
(7328, 177, '36221', '552', '5522108V000', '1ND', 'OP PIK ALTEKO Zmrhal', 'XXXtmpXXXmareslud', '2023-01-01', '2023-12-31', '0.50', '2', 0, 13750, 0, 0, 0, 13750, 13750, 18398, 18535, 27500, '', 'ne', 'ne', 'neni', 0, 1, 'W-5723', '1', 'W-5782', '0000-00-00', '0000-00-00'),
(7329, 199, '', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'salkokat', '2023-01-01', '2038-12-30', '0.20', '6', 0, 4960, 3840, 0, 0, 8800, 8800, 11774, 11862, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5727', '1', 'W-5777', '0000-00-00', '0000-00-00'),
(7330, 225, '', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'salkokat', '2023-01-01', '2038-12-30', '0.20', '6', 0, 4962, 3838, 0, 0, 8800, 8800, 11774, 11862, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5727', '2', 'W-5777', '0000-00-00', '0000-00-00'),
(7331, 305, '', '661', '6612201V000', '1ND', 'Šance pro budovy ECF - Vlasatá', 'salkokat', '2023-01-01', '2038-12-30', '0.10', '6', 0, 2481, 1919, 0, 0, 4400, 4400, 5887, 5931, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5727', '3', 'W-5777', '0000-00-00', '0000-00-00'),
(7349, 213, '36910', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'seibejan', '2023-01-01', '2023-12-31', '1.00', '6', 0, 35000, 34500, 0, 0, 69500, 69500, 92991, 93686, 69500, '', 'ne', 'ne', 'B4', 71500, 1, 'W-5748', '1', 'W-5908', '0000-00-00', '0000-00-00'),
(7355, 189, '36221', '552', '5522109V000', '1ND', 'OP PIK QUANTUM', 'vavrirom', '2022-10-01', '2038-12-30', '0.40', 'A3', 0, 12400, 7600, 0, 0, 20000, 20000, 26760, 26960, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5753', '1', 'W-5755', '0000-00-00', '0000-00-00'),
(7356, 248, '36221', '552', '5522202V000', '1ND', 'OP PIK IX KARBOX II', 'vavrirom', '2022-10-01', '2038-12-30', '0.25', 'A3', 0, 7750, 4750, 0, 0, 12500, 12500, 16725, 16850, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5753', '2', 'W-5755', '0000-00-00', '0000-00-00'),
(7362, 183, '36242', '552', '5522112V000', '1ND', 'OP PIK FASHEX / Dekmetal', 'prosezde', '2023-01-01', '2023-12-31', '0.40', '5', 0, 15600, 8400, 0, 0, 24000, 24000, 32112, 32352, 60000, '', 'ne', 'ne', 'B5', 75000, 1, 'W-5757', '1', 'W-5863', '0000-00-00', '0000-00-00'),
(7378, 248, '36221', '552', '5522202V000', '1ND', 'OP PIK IX KARBOX II', 'sulcvlad', '2023-01-01', '2023-12-31', '0.50', 'A3', 0, 15500, 7000, 0, 0, 22500, 22500, 30105, 30330, 45000, '', 'ne', 'ne', 'B6', 53900, 1, 'W-5770', '1', 'W-5861', '0000-00-00', '0000-00-00'),
(7396, 199, '36216', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'salkokat', '2023-01-01', '2038-12-30', '0.20', '6', 0, 4960, 3840, 0, 0, 8800, 8800, 11774, 11862, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5777', '1', 'W-5870', '0000-00-00', '0000-00-00'),
(7397, 225, '36216', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'salkokat', '2023-01-01', '2038-12-30', '0.20', '6', 0, 4962, 3838, 0, 0, 8800, 8800, 11774, 11862, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5777', '2', 'W-5870', '0000-00-00', '0000-00-00'),
(7398, 305, '36216', '661', '6612201V000', '1ND', 'Šance pro budovy ECF - Vlasatá', 'salkokat', '2023-01-01', '2038-12-30', '0.10', '6', 0, 2481, 1919, 0, 0, 4400, 4400, 5887, 5931, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5777', '3', 'W-5870', '0000-00-00', '0000-00-00'),
(7413, 135, '36211', '311', '3112101A132', '1ND', 'TAČR PPŽ - DECOMPOSE', 'mariadia', '2023-02-01', '2038-12-30', '0.40', '6', 0, 9924, 4876, 0, 0, 14800, 14800, 19802, 19950, 37000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5714', '1', 'W-5970', '0000-00-00', '0000-00-00'),
(7414, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'hodkojul', '2023-01-01', '2023-12-31', '0.01', '7', 0, 330, 300, 0, 0, 630, 630, 843, 849, 63000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5784', '1', 'W-5879', '0000-00-00', '0000-00-00'),
(7415, 74, '36216', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'hodkojul', '2023-01-01', '2023-12-31', '0.37', '7', 0, 12210, 11100, 0, 0, 23310, 23310, 31189, 31422, 63000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5784', '2', 'W-5879', '0000-00-00', '0000-00-00'),
(7416, 47, '36216', '165', '1651901V000', '1ND', 'MŠMT INTER TRANSFER Annex 72 - životní cyklus budov', 'hodkojul', '2023-01-01', '2023-12-31', '0.01', '7', 0, 330, 300, 0, 0, 630, 630, 843, 849, 63000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5784', '3', 'W-5879', '0000-00-00', '0000-00-00'),
(7417, 305, '36216', '661', '6612201V000', '1ND', 'Šance pro budovy ECF - Vlasatá', 'hodkojul', '2023-01-01', '2023-12-31', '0.01', '7', 0, 330, 300, 0, 0, 630, 630, 843, 849, 63000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5784', '4', 'W-5879', '0000-00-00', '0000-00-00'),
(7418, 225, '36216', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'hodkojul', '2023-01-01', '2023-12-31', '0.60', '7', 0, 19800, 18000, 0, 0, 37800, 37800, 50576, 50954, 63000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5784', '5', 'W-5879', '0000-00-00', '0000-00-00'),
(7420, 223, '36213', '301', '3012212A124', '1ND', 'GAČR LA - TRC Slovinsko - Hájek', 'hejtmpet', '2022-03-01', '2022-03-31', '0.30', 'A3', 0, 9300, 9300, 0, 0, 18600, 18600, 24887, 25073, 62000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5790', '1', 'W-5791', '0000-00-00', '0000-00-00'),
(7421, 2, '36213', '222', '2221901V000', '1ND', 'MVČR - BV Hejtmánek', 'hejtmpet', '2022-03-01', '2022-03-31', '0.30', 'A3', 0, 9300, 9300, 0, 0, 18600, 18600, 24887, 25073, 62000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5790', '2', 'W-5791', '0000-00-00', '0000-00-00'),
(7555, 353, '36211', '661', '6612301V000', '1ND', 'INDICATE LaudesF - Železná', 'hajekpet', '2023-01-01', '2038-12-30', '0.10', 'A5', 0, 10001, 2472, 0, 0, 12473, 12473, 16689, 16814, 124729, '', 'ne', 'ne', 'neni', 0, 1, 'W-5866', '1', 'W-5960', '0000-00-00', '0000-00-00'),
(7556, 128, '36216', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'ruzicjan', '2023-01-01', '2038-12-30', '0.15', 'A3', 0, 4650, 3900, 0, 0, 8550, 8550, 11440, 11525, 57000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5867', '1', 'W-5961', '0000-00-00', '0000-00-00'),
(7557, 353, '36216', '661', '6612301V000', '1ND', 'INDICATE LaudesF - Železná', 'ruzicjan', '2023-01-01', '2038-12-30', '0.15', 'A3', 0, 4650, 3900, 0, 0, 8550, 8550, 11440, 11525, 57000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5867', '2', 'W-5961', '0000-00-00', '0000-00-00'),
(7570, 198, '36212', '552', '5522116V000', '1ND', 'OP PIK ZdrOk / VEKRA', 'stanekam', '2023-01-01', '2038-12-30', '1.00', 'A3', 0, 31000, 34000, 0, 0, 65000, 65000, 86970, 87620, 65000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5874', '1', 'W-5915', '0000-00-00', '0000-00-00'),
(7640, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'reistkri', '2023-01-01', '2038-12-30', '0.20', '6', 0, 4962, 4278, 0, 0, 9240, 9240, 12363, 12456, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5900', '1', 'W-5937', '0000-00-00', '0000-00-00'),
(7641, 256, '36920', '552', '5522122V000', '1ND', 'OP PIK IX RoboPID', 'reistkri', '2023-01-01', '2038-12-30', '0.40', '6', 0, 9924, 8556, 0, 0, 18480, 18480, 24726, 24911, 46200, '', 'ne', 'ano', 'B4', 49500, 1, 'W-5900', '2', 'W-5937', '0000-00-00', '0000-00-00'),
(7642, 128, '36920', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'reistkri', '2023-01-01', '2038-12-30', '0.25', '6', 0, 6203, 5347, 0, 0, 11550, 11550, 15454, 15569, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5900', '3', 'W-5937', '0000-00-00', '0000-00-00'),
(7643, 243, '36920', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'reistkri', '2023-01-01', '2038-12-30', '0.15', '6', 0, 3722, 3208, 0, 0, 6930, 6930, 9272, 9342, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5900', '4', 'W-5937', '0000-00-00', '0000-00-00'),
(7655, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'holecste', '2023-01-01', '2038-12-30', '0.94', '6', 0, 23321, 20013, 0, 0, 43334, 43334, 57981, 58414, 46100, '', 'ne', 'ne', 'neni', 0, 1, 'W-5902', '1', 'W-5956', '0000-00-00', '0000-00-00'),
(7656, 270, '36920', '311', '3112207V000', '1ND', 'TAČR BETA - Energetické komunity - Vácha', 'holecste', '2023-01-01', '2038-12-30', '0.06', '6', 0, 1489, 1277, 0, 0, 2766, 2766, 3701, 3729, 46100, '', 'ne', 'ne', 'neni', 0, 1, 'W-5902', '2', 'W-5956', '0000-00-00', '0000-00-00'),
(7667, 213, '36920', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'rutovmar', '2023-01-01', '2023-12-31', '1.00', '6', 0, 24810, 17190, 0, 0, 42000, 42000, 56196, 56616, 42000, '', 'ne', 'ano', 'B7', 47300, 1, 'W-5909', '1', 'W-5957', '0000-00-00', '0000-00-00'),
(7674, 91, '36940', '888', '8889701V000', '9NN', 'Režie - ostatní', 'virabohd', '2023-01-01', '2038-12-30', '0.55', '6', 0, 19250, 14300, 0, 0, 33550, 33550, 44890, 45225, 61000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5899', '1', 'W-5922', '0000-00-00', '0000-00-00'),
(7675, 197, '36940', '552', '5522110V000', '1ND', 'OP PIK Multi-Heat / TECHTRANS', 'virabohd', '2023-01-01', '2038-12-30', '0.16', '6', 0, 5600, 4160, 0, 0, 9760, 9760, 13059, 13156, 61000, '', 'ne', 'ne', 'B2', 66000, 1, 'W-5899', '2', 'W-5922', '0000-00-00', '0000-00-00'),
(7676, 191, '36940', '552', '5522114V000', '1ND', 'OP PIK Senzor viskozity', 'virabohd', '2023-01-01', '2038-12-30', '0.09', '6', 0, 3150, 2340, 0, 0, 5490, 5490, 7346, 7401, 61000, '', 'ne', 'ne', 'B5', 75900, 1, 'W-5899', '3', 'W-5922', '0000-00-00', '0000-00-00'),
(7678, 268, '36261', '312', '3122204V000', '1ND', 'MetaMorph - TAČR KAPPA - InoCure', 'novotan8', '2023-01-01', '2023-01-31', '0.28', '6', 0, 6947, 4253, 0, 0, 11200, 11200, 14986, 15098, 40000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5912', '1', 'W-6184', '2023-01-01', '2038-12-30'),
(7679, 264, '36261', '312', '3122203V000', '1ND', 'NextPhage - TAČR TREND III - InoCure', 'novotan8', '2023-01-01', '2023-01-31', '0.42', '6', 0, 10420, 6380, 0, 0, 16800, 16800, 22478, 22646, 40000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5912', '2', 'W-6184', '2023-01-01', '2038-12-30'),
(7680, 84, '36261', '312', '3122001V000', '1ND', 'TAČR ETA III - VVTO - Odorologie ', 'divinrad', '2023-01-01', '2023-01-31', '0.58', '6', 0, 24276, 19652, 0, 0, 43928, 43928, 58776, 59215, 76000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5913', '1', 'W-6185', '2023-01-01', '2038-12-30'),
(7681, 245, '36261', '221', '2212201V000', '1ND', 'MVČR SECTECH NANOPACH', 'divinrad', '2023-01-01', '2023-01-31', '0.03', '6', 0, 1344, 1088, 0, 0, 2432, 2432, 3254, 3278, 76000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5913', '2', 'W-6185', '2023-01-01', '2038-12-30'),
(7682, 264, '36261', '312', '3122203V000', '1ND', 'NextPhage - TAČR TREND III - InoCure', 'divinrad', '2023-01-01', '2023-01-31', '0.09', '6', 0, 3780, 3060, 0, 0, 6840, 6840, 9152, 9220, 76000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5913', '3', 'W-6185', '2023-01-01', '2038-12-30'),
(7694, 91, '36940', '888', '8889701V000', '9NN', 'Režie - ostatní', 'virabohd', '2023-01-01', '2038-12-30', '0.55', '6', 0, 19250, 14300, 0, 0, 33550, 33550, 44890, 45225, 61000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5922', '1', 'W-5923', '0000-00-00', '0000-00-00'),
(7695, 197, '36940', '552', '5522110V000', '1ND', 'OP PIK Multi-Heat / TECHTRANS', 'virabohd', '2023-01-01', '2038-12-30', '0.16', '6', 0, 5600, 4160, 0, 0, 9760, 9760, 13059, 13156, 61000, '', 'ne', 'ne', 'B2', 66000, 0, 'W-5922', '2', 'W-5923', '0000-00-00', '0000-00-00'),
(7696, 256, '36940', '552', '5522122V000', '1ND', 'OP PIK IX RoboPID', 'virabohd', '2023-01-01', '2038-12-30', '0.09', '6', 0, 3150, 2340, 0, 0, 5490, 5490, 7346, 7401, 61000, '', 'ne', 'ne', 'B3', 66000, 0, 'W-5922', '3', 'W-5923', '0000-00-00', '0000-00-00'),
(7700, 195, '36244', '552', '5522106V000', '1ND', 'OP PIK MOB-Bars FSv', 'sovjarad', '2023-01-01', '2023-05-31', '0.45', 'A4', 0, 18900, 15750, 0, 0, 34650, 34650, 46362, 46708, 77000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5924', '1', 'W-5931', '0000-00-00', '0000-00-00'),
(7701, 195, '36244', '552', '5522106V000', '1ND', 'OP PIK MOB-Bars FSv', 'konrape2', '2023-01-01', '2023-05-31', '0.50', 'A3', 0, 15500, 12000, 0, 0, 27500, 27500, 36795, 37070, 55000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5925', '1', 'W-5932', '0000-00-00', '0000-00-00'),
(7702, 195, '36244', '552', '5522106V000', '1ND', 'OP PIK MOB-Bars FSv', 'joglmarc', '2023-01-01', '2023-05-31', '0.20', '6', 0, 6200, 2600, 0, 0, 8800, 8800, 11774, 11862, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5926', '1', 'W-5933', '0000-00-00', '0000-00-00'),
(7703, 195, '36244', '552', '5522106V000', '1ND', 'OP PIK MOB-Bars FSv', 'joglluka', '2023-01-01', '2023-05-31', '0.20', '4', 0, 6200, 2600, 0, 0, 8800, 8800, 11774, 11862, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5927', '1', 'W-5934', '0000-00-00', '0000-00-00'),
(7704, 195, '36244', '552', '5522106V000', '1ND', 'OP PIK MOB-Bars FSv', 'XXXtmpXXXsedlasim', '2023-01-01', '2023-05-31', '0.30', '5', 0, 12002, 1198, 0, 0, 13200, 13200, 17662, 17794, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5928', '1', 'W-5935', '0000-00-00', '0000-00-00'),
(7708, 195, '36244', '552', '5522106V000', '1ND', 'OP PIK MOB-Bars FSv', 'joglluka', '2023-01-01', '2023-05-31', '0.20', '4', 0, 6200, 1800, 0, 0, 8000, 8000, 10704, 10784, 40000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5934', '1', 'W-5977', '0000-00-00', '0000-00-00'),
(7710, 117, '36920', '302', '3022101V000', '1ND', 'GAČR - LEFM', 'stoladan', '2023-01-01', '2038-12-30', '0.12', '6', 0, 3126, 2418, 0, 0, 5544, 5544, 7418, 7473, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5936', '1', 'W-5944', '0000-00-00', '0000-00-00'),
(7711, 167, '36920', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'stoladan', '2023-01-01', '2038-12-30', '0.05', '6', 0, 1302, 1008, 0, 0, 2310, 2310, 3091, 3114, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5936', '2', 'W-5944', '0000-00-00', '0000-00-00'),
(7712, 213, '36920', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'stoladan', '2023-01-01', '2038-12-30', '0.12', '6', 0, 3126, 2418, 0, 0, 5544, 5544, 7418, 7473, 46200, '', 'ne', 'ne', 'B7', 47300, 1, 'W-5936', '3', 'W-5944', '0000-00-00', '0000-00-00'),
(7713, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'stoladan', '2023-01-01', '2038-12-30', '0.10', '6', 0, 2605, 1795, 0, 0, 4400, 4400, 5887, 5931, 44000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5936', '6', 'W-5944', '0000-00-00', '0000-00-00'),
(7714, 129, '36920', '312', '3122003V000', '1ND', 'TAČR TREND II - FullSpectraSun (Spectrasol)', 'stoladan', '2023-01-01', '2038-12-30', '0.08', '6', 0, 2084, 1612, 0, 0, 3696, 3696, 4945, 4982, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5936', '7', 'W-5944', '0000-00-00', '0000-00-00'),
(7715, 279, '36920', '661', '6612202V000', '1ND', 'Cir4ConClimate EUKI - Pavlů', 'stoladan', '2023-01-01', '2038-12-30', '0.53', '6', 0, 13806, 10680, 0, 0, 24486, 24486, 32762, 33007, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5936', '8', 'W-5944', '0000-00-00', '0000-00-00'),
(7734, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'danickar', '2023-03-01', '2023-12-31', '1.00', '4', 0, 21510, 10490, 0, 0, 32000, 32000, 42816, 43136, 32000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5948', '1', 'W-6075', '0000-00-00', '0000-00-00'),
(7743, 261, '36244', '552', '5522121V000', '1ND', 'OP PIK Alimex', 'XXXtmpXXX	lennero1', '2023-01-01', '2023-05-31', '0.45', 'A3', 0, 24052, 11948, 0, 0, 36000, 36000, 48168, 48528, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5953', '1', 'W-6154', '0000-00-00', '0000-00-00'),
(7749, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'rutovmar', '2023-01-01', '2023-12-31', '1.00', '6', 0, 24810, 17190, 0, 0, 42000, 42000, 56196, 56616, 42000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5957', '1', 'W-5958', '0000-00-00', '0000-00-00'),
(7764, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'novotva5', '2023-03-01', '2038-12-30', '0.10', 'A3', 0, 3100, 2329, 0, 0, 5429, 5429, 7264, 7318, 54285, '', 'ne', 'ne', 'neni', 0, 1, 'W-5968', '1', 'W-5980', '0000-00-00', '0000-00-00'),
(7765, 208, '36215', '604', '6042201V000', '1ND', 'H2020 - ARV', ' petrema1', '2023-03-01', '2023-12-31', '0.60', '6', 0, 14886, 7914, 0, 0, 22800, 22800, 30506, 30734, 38000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5969', '1', 'W-6057', '0000-00-00', '0000-00-00'),
(7766, 135, '36211', '311', '3112101A132', '1ND', 'TAČR PPŽ - DECOMPOSE', 'mariadia', '2023-02-01', '2038-12-30', '0.75', '6', 0, 18608, 9143, 0, 0, 27750, 27750, 37130, 37407, 37000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5970', '1', 'W-6118', '0000-00-00', '0000-00-00'),
(7784, 84, '36261', '312', '3122001V000', '1ND', 'TAČR ETA III - VVTO - Odorologie ', 'amlerevz', '2023-02-01', '2038-12-30', '0.54', '7', 0, 27000, 20245, 0, 0, 47246, 47246, 63215, 63688, 87492, '', 'ne', 'ne', 'neni', 0, 1, 'W-5984', '1', 'W-6006', '0000-00-00', '0000-00-00'),
(7785, 245, '36261', '221', '2212201V000', '1ND', 'MVČR SECTECH NANOPACH', 'amlerevz', '2023-02-01', '2038-12-30', '0.16', '7', 0, 8000, 5999, 0, 0, 13999, 13999, 18731, 18871, 87492, '', 'ne', 'ne', 'neni', 0, 1, 'W-5984', '2', 'W-6006', '0000-00-00', '0000-00-00'),
(7786, 84, '36261', '312', '3122001V000', '1ND', 'TAČR ETA III - VVTO - Odorologie ', 'divinrad', '2023-02-01', '2038-12-30', '0.35', '6', 0, 14700, 11900, 0, 0, 26600, 26600, 35591, 35857, 76000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5985', '1', 'W-6005', '0000-00-00', '0000-00-00'),
(7787, 245, '36261', '221', '2212201V000', '1ND', 'MVČR SECTECH NANOPACH', 'divinrad', '2023-02-01', '2038-12-30', '0.03', '6', 0, 1344, 1088, 0, 0, 2432, 2432, 3254, 3278, 76000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5985', '2', 'W-6005', '0000-00-00', '0000-00-00'),
(7788, 264, '36261', '312', '3122203V000', '1ND', 'NextPhage - TAČR TREND III - InoCure', 'divinrad', '2023-02-01', '2038-12-30', '0.32', '6', 0, 13356, 10812, 0, 0, 24168, 24168, 32337, 32578, 76000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5985', '3', 'W-6005', '0000-00-00', '0000-00-00'),
(7794, 256, '36251', '552', '5522122V000', '1ND', 'OP PIK IX RoboPID', 'wawerrob', '2023-02-01', '2038-12-30', '0.05', '7', 0, 2750, 850, 0, 250, 3850, 3600, 5151, 5190, 72000, '', 'ne', 'ne', 'B1', 77000, 1, 'W-5989', '1', 'W-5991', '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`, `stav`, `idAplikace`, `idAplikace2`, `idAplikaceKteraZpusobilaZmenu`, `puvodni_na_projektu_od`, `puvodni_na_projektu_do`) VALUES
(7795, 213, '36251', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'wawerrob', '2023-02-01', '2038-12-30', '0.90', '7', 0, 49500, 15300, 0, 4500, 69300, 64800, 92723, 93416, 72000, '', 'ne', 'ne', 'B1', 78856, 1, 'W-5989', '2', 'W-5991', '0000-00-00', '0000-00-00'),
(7796, 208, '36251', '604', '6042201V000', '1ND', 'H2020 - ARV', 'wawerrob', '2023-02-01', '2038-12-30', '0.05', '7', 0, 2750, 850, 0, 250, 3850, 3600, 5151, 5190, 72000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5989', '3', 'W-5991', '0000-00-00', '0000-00-00'),
(7813, 268, '36261', '312', '3122204V000', '1ND', 'MetaMorph - TAČR KAPPA - InoCure', 'novotan8', '2023-02-01', '2023-03-31', '0.65', '6', 0, 16127, 9873, 0, 0, 26000, 26000, 34788, 35048, 40000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5983', '1', 'W-6184', '2023-02-01', '2024-04-30'),
(7814, 264, '36261', '312', '3122203V000', '1ND', 'NextPhage - TAČR TREND III - InoCure', 'novotan8', '2023-02-01', '2023-03-31', '0.05', '6', 0, 1241, 759, 0, 0, 2000, 2000, 2676, 2696, 40000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5983', '2', 'W-6184', '2023-02-01', '2024-04-30'),
(7816, 268, '36920', '312', '3122204V000', '1ND', 'MetaMorph - TAČR KAPPA - InoCure', 'tomeska1', '2023-02-01', '2038-12-30', '0.50', '6', 0, 20000, 15700, 0, 1000, 36700, 35700, 49105, 49472, 71400, '', 'ne', 'ne', 'neni', 0, 1, 'W-6013', '1', 'W-6017', '0000-00-00', '0000-00-00'),
(7817, 112, '36920', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'tomeska1', '2023-02-01', '2038-12-30', '0.05', '6', 0, 2000, 1570, 0, 100, 3670, 3570, 4910, 4947, 71400, '', 'ne', 'ne', 'neni', 0, 1, 'W-6013', '2', 'W-6017', '0000-00-00', '0000-00-00'),
(7818, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'tomeska1', '2023-02-01', '2038-12-30', '0.45', '6', 0, 18000, 14130, 0, 900, 33030, 32130, 44194, 44524, 71400, '', 'ne', 'ne', 'neni', 0, 1, 'W-6013', '3', 'W-6017', '0000-00-00', '0000-00-00'),
(7846, 117, '36920', '302', '3022101V000', '1ND', 'GAČR - LEFM', 'stoladan', '2023-03-01', '2038-12-30', '0.12', '6', 0, 3126, 2418, 0, 0, 5544, 5544, 7418, 7473, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6030', '1', 'W-6089', '0000-00-00', '0000-00-00'),
(7847, 167, '36920', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'stoladan', '2023-03-01', '2038-12-30', '0.05', '6', 0, 1303, 1008, 0, 0, 2310, 2310, 3091, 3114, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6030', '2', 'W-6089', '0000-00-00', '0000-00-00'),
(7848, 189, '36920', '552', '5522109V000', '1ND', 'OP PIK QUANTUM', 'stoladan', '2023-03-01', '2038-12-30', '0.10', '6', 0, 2605, 2015, 0, 0, 4620, 4620, 6182, 6228, 46200, '', 'ne', 'ne', 'B7', 47300, 1, 'W-6030', '3', 'W-6089', '0000-00-00', '0000-00-00'),
(7849, 279, '36920', '661', '6612202V000', '1ND', 'Cir4ConClimate EUKI - Pavlů', 'stoladan', '2023-03-01', '2038-12-30', '0.53', '6', 0, 13807, 10680, 0, 0, 24486, 24486, 32762, 33007, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6030', '4', 'W-6089', '0000-00-00', '0000-00-00'),
(7968, 231, '36222', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'mascujak', '2023-04-01', '2038-12-30', '0.10', 'A3', 0, 3100, 3396, 0, 1875, 8371, 6496, 11200, 11284, 64960, '', 'ne', 'ne', 'neni', 0, 0, 'W-6110', '1', 'W-6111', '0000-00-00', '0000-00-00'),
(7969, 90, '36222', '312', '3122002V000', '1ND', 'TAČR THETA III Data4energy', 'mascujak', '2023-04-01', '2038-12-30', '0.20', 'A3', 0, 6200, 6792, 0, 1875, 14867, 12992, 19892, 20041, 64960, '', 'ne', 'ne', 'neni', 0, 0, 'W-6110', '2', 'W-6111', '0000-00-00', '0000-00-00'),
(7970, 325, '36222', '312', '3122301V000', '1ND', 'EE1 TAČR Théta V - Maščuch', 'mascujak', '2023-04-01', '2038-12-30', '0.20', 'A3', 0, 6200, 6792, 0, 0, 12992, 12992, 17383, 17513, 64960, '', 'ne', 'ne', 'neni', 0, 0, 'W-6110', '3', 'W-6111', '0000-00-00', '0000-00-00'),
(7971, 157, '', '661', '6612001V000', '1ND', 'EUKI - Energy Efficiency Network', 'mascujak', '2023-04-01', '2038-12-30', '0.10', 'A3', 0, 3100, 3396, 0, 0, 6496, 6496, 8692, 8757, 64960, '', 'ne', 'ne', 'neni', 0, 0, 'W-6110', '4', 'W-6111', '0000-00-00', '0000-00-00'),
(7972, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'mascujak', '2023-04-01', '2038-12-30', '0.20', 'A3', 0, 6200, 6792, 0, 1250, 14242, 12992, 19056, 19198, 64960, '', 'ne', 'ne', 'neni', 0, 0, 'W-6110', '5', 'W-6111', '0000-00-00', '0000-00-00'),
(8018, 179, '36252', '552', '5522103V000', '1ND', 'OP PIK Energocentrum II SCADA BI', 'tabacjar', '2023-06-01', '2024-12-31', '1.00', '6', 0, 28000, 26000, 6000, 0, 60000, 54000, 80280, 80880, 54000, '', 'ne', 'ne', 'B5', 66000, 1, 'W-6131', '1', 'W-6204', '0000-00-00', '0000-00-00'),
(8025, 245, '36261', '221', '2212201V000', '1ND', 'MVČR SECTECH NANOPACH', 'amlerevz', '2023-04-01', '2038-12-30', '0.10', '7', 0, 5000, 3749, 0, 0, 8749, 8749, 11706, 11794, 87492, '', 'ne', 'ne', 'neni', 0, 1, 'W-6135', '1', 'W-6169', '0000-00-00', '0000-00-00'),
(8026, 264, '36261', '312', '3122203V000', '1ND', 'NextPhage - TAČR TREND III - InoCure', 'amlerevz', '2023-04-01', '2038-12-30', '0.10', '7', 0, 5000, 3749, 0, 0, 8749, 8749, 11706, 11794, 87492, '', 'ne', 'ne', 'neni', 0, 1, 'W-6135', '2', 'W-6169', '0000-00-00', '0000-00-00'),
(8027, 268, '36261', '312', '3122204V000', '1ND', 'MetaMorph - TAČR KAPPA - InoCure', 'amlerevz', '2023-04-01', '2038-12-30', '0.80', '7', 0, 40000, 29993, 0, 0, 69994, 69994, 93652, 94352, 87492, '', 'ne', 'ne', 'neni', 0, 1, 'W-6135', '3', 'W-6169', '0000-00-00', '0000-00-00'),
(8028, 264, '36261', '312', '3122203V000', '1ND', 'NextPhage - TAČR TREND III - InoCure', 'divinrad', '2023-04-01', '2038-12-30', '0.10', '6', 0, 4200, 3400, 0, 0, 7600, 7600, 10169, 10245, 76000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6136', '1', 'W-6170', '0000-00-00', '0000-00-00'),
(8029, 245, '36261', '221', '2212201V000', '1ND', 'MVČR SECTECH NANOPACH', 'divinrad', '2023-04-01', '2038-12-30', '0.10', '6', 0, 4200, 3400, 0, 0, 7600, 7600, 10169, 10245, 76000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6136', '2', 'W-6170', '0000-00-00', '0000-00-00'),
(8030, 268, '36261', '312', '3122204V000', '1ND', 'MetaMorph - TAČR KAPPA - InoCure', 'divinrad', '2023-04-01', '2038-12-30', '0.50', '6', 0, 21000, 17000, 0, 0, 38000, 38000, 50844, 51224, 76000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6136', '3', 'W-6170', '0000-00-00', '0000-00-00'),
(8031, 213, '36251', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'solomser', '2023-06-01', '2023-12-31', '1.00', '5', 0, 24810, 15190, 3000, 0, 43000, 40000, 57534, 57964, 40000, '', 'ne', 'ne', 'B7', 47300, 1, 'W-6140', '1', 'W-6322', '0000-00-00', '0000-00-00'),
(8032, 218, '36253', '552', '5522115V000', '1ND', 'OP PIK SANS SOUCI', 'vanekj15', '2023-06-01', '2024-12-31', '1.00', '5', 0, 29462, 14538, 4000, 0, 48000, 44000, 64224, 64704, 44000, '', 'ano', 'ne', 'B5', 66000, 1, 'W-3631', '1', 'W-6357', '0000-00-00', '0000-00-00'),
(8040, 268, '36261', '312', '3122204V000', '1ND', 'MetaMorph - TAČR KAPPA - InoCure', 'novotan8', '2023-04-01', '2023-06-30', '0.65', '6', 0, 16127, 9873, 0, 0, 26000, 26000, 34788, 35048, 40000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6144', '1', 'W-6184', '0000-00-00', '0000-00-00'),
(8041, 264, '36261', '312', '3122203V000', '1ND', 'NextPhage - TAČR TREND III - InoCure', 'novotan8', '2023-04-01', '2023-06-30', '0.05', '6', 0, 1241, 759, 0, 0, 2000, 2000, 2676, 2696, 40000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6144', '2', 'W-6184', '0000-00-00', '0000-00-00'),
(8059, 213, '36930', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'pospika4', '2023-04-01', '2038-12-30', '0.35', '6', 0, 8684, 7486, 0, 0, 16170, 16170, 21635, 21797, 46200, '', 'ne', 'ne', 'B7', 47300, 1, 'W-6157', '2', 'W-6163', '0000-00-00', '0000-00-00'),
(8060, 180, '36930', '552', '5522105V000', '1ND', 'OP PIK LASSO', 'pospika4', '2023-04-01', '2038-12-30', '0.13', '6', 0, 3226, 2780, 0, 0, 6006, 6006, 8036, 8096, 46200, '', 'ne', 'ne', 'B8', 46200, 1, 'W-6157', '3', 'W-6163', '0000-00-00', '0000-00-00'),
(8061, 187, '36930', '552', '5522107V000', '1ND', 'OP PIK DH4.ENERGY / Feramat', 'pospika4', '2023-04-01', '2038-12-30', '0.23', '6', 0, 5708, 4918, 0, 0, 10626, 10626, 14218, 14324, 46200, '', 'ne', 'ne', 'B5', 51000, 1, 'W-6157', '4', 'W-6163', '0000-00-00', '0000-00-00'),
(8062, 254, '36930', '552', '5522124V000', '1ND', 'OP PIK IX EXPECT-IT II', 'pospika4', '2023-04-01', '2038-12-30', '0.14', '6', 0, 3473, 2995, 0, 0, 6468, 6468, 8654, 8719, 46200, '', 'ne', 'ano', 'B7', 47300, 1, 'W-6157', '5', 'W-6163', '0000-00-00', '0000-00-00'),
(8063, 255, '36930', '552', '5522201V000', '1ND', 'OP PIK IX MiniBio', 'pospika4', '2023-04-01', '2038-12-30', '0.15', '6', 0, 3723, 3208, 0, 0, 6930, 6930, 9272, 9342, 46200, '', 'ne', 'ne', 'B5', 49060, 1, 'W-6157', '6', 'W-6163', '0000-00-00', '0000-00-00'),
(8112, 268, '36261', '312', '3122204V000', '1ND', 'MetaMorph - TAČR KAPPA - InoCure', 'houskkat', '2023-05-01', '2023-12-31', '0.34', '4', 0, 10540, 9860, 0, 0, 20400, 20400, 27295, 27499, 60000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6176', '1', 'W-6238', '0000-00-00', '0000-00-00'),
(8197, 213, '36254', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'kichosof', '2023-05-01', '2038-12-30', '0.70', '7', 0, 19356, 17744, 2100, 0, 39200, 37100, 52450, 52842, 53000, '', 'ne', 'ne', 'B5', 69300, 1, 'W-6190', '1', 'W-6252', '0000-00-00', '0000-00-00'),
(8198, 208, '36254', '604', '6042201V000', '1ND', 'H2020 - ARV', 'kichosof', '2023-05-01', '2038-12-30', '0.30', '7', 0, 8295, 7605, 900, 0, 16800, 15900, 22478, 22646, 53000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6190', '2', 'W-6252', '0000-00-00', '0000-00-00'),
(8270, 117, '36241', '302', '3022101V000', '1ND', 'GAČR - LEFM', 'postajan', '2023-06-01', '2038-12-30', '0.15', '7', 0, 5250, 3750, 0, 0, 9000, 9000, 12042, 12132, 60000, '', 'ne', 'ne', 'neni', 0, 0, 'W-6268', '1', 'W-6269', '0000-00-00', '0000-00-00'),
(8271, 225, '36241', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'postajan', '2023-06-01', '2038-12-30', '0.40', '7', 0, 14000, 10000, 0, 2500, 26500, 24000, 35457, 35722, 60000, '', 'ne', 'ne', 'neni', 0, 0, 'W-6268', '2', 'W-6269', '0000-00-00', '0000-00-00'),
(8272, 250, '36241', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'postajan', '2023-06-01', '2038-12-30', '0.25', '7', 0, 8750, 6250, 0, 2500, 17500, 15000, 23415, 23590, 60000, '', 'ne', 'ne', 'neni', 0, 0, 'W-6268', '3', 'W-6269', '0000-00-00', '0000-00-00'),
(8273, 392, '36241', '122', '1225201X000', '1ND', 'Modifikace odprašků FBČVUT - Prošek', 'postajan', '2023-06-01', '2038-12-30', '0.20', '7', 0, 7000, 5000, 0, 0, 12000, 12000, 16056, 16176, 60000, '', 'ne', 'ne', 'neni', 0, 0, 'W-6268', '4', 'W-6269', '0000-00-00', '0000-00-00'),
(8278, 157, '36920', '661', '6612001V000', '1ND', 'EUKI - Energy Efficiency Network', 'stoladan', '2023-06-01', '2038-12-30', '0.12', '6', 0, 3126, 2418, 0, 0, 5544, 5544, 7418, 7473, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6270', '1', 'W-6386', '0000-00-00', '0000-00-00'),
(8279, 167, '36920', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'stoladan', '2023-06-01', '2038-12-30', '0.05', '6', 0, 1303, 1008, 0, 0, 2310, 2310, 3091, 3114, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6270', '2', 'W-6386', '0000-00-00', '0000-00-00'),
(8280, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'stoladan', '2023-06-01', '2038-12-30', '0.30', '6', 0, 7815, 6045, 0, 0, 13860, 13860, 18545, 18683, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6270', '3', 'W-6386', '0000-00-00', '0000-00-00'),
(8281, 279, '36920', '661', '6612202V000', '1ND', 'Cir4ConClimate EUKI - Pavlů', 'stoladan', '2023-06-01', '2038-12-30', '0.53', '6', 0, 13807, 10680, 0, 0, 24486, 24486, 32762, 33007, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6270', '4', 'W-6386', '0000-00-00', '0000-00-00'),
(8316, 199, '36212', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'hejljaro', '2023-06-01', '2038-12-30', '0.75', '6', 0, 18608, 9892, 0, 0, 28500, 28500, 38133, 38418, 38000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6285', '1', 'W-6796', '0000-00-00', '0000-00-00'),
(8333, 302, '36211', '606', '6062303V000', '1ND', 'CIRC-BOOST HE - Pavlů', 'pavluter', '2023-06-01', '2023-08-31', '0.20', 'A3', 0, 8000, 7000, 0, 0, 15000, 15000, 20070, 20220, 75000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6294', '1', 'W-6940', '2023-06-01', '2038-12-30'),
(8334, 135, '36211', '311', '3112101A132', '1ND', 'TAČR PPŽ - DECOMPOSE', 'pavluter', '2023-06-01', '2023-08-31', '0.06', 'A3', 0, 2400, 2100, 0, 0, 4500, 4500, 6021, 6066, 75000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6294', '2', 'W-6940', '2023-06-01', '2038-12-30'),
(8335, 279, '36211', '661', '6612202V000', '1ND', 'Cir4ConClimate EUKI - Pavlů', 'pavluter', '2023-06-01', '2023-08-31', '0.49', 'A3', 0, 19600, 17150, 0, 0, 36750, 36750, 49172, 49539, 75000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6294', '3', 'W-6940', '2023-06-01', '2038-12-30'),
(8423, 128, '36920', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'reistkri', '2023-06-01', '2038-12-30', '0.25', '6', 0, 6203, 5347, 0, 0, 11550, 11550, 15454, 15569, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6328', '1', 'W-6385', '0000-00-00', '0000-00-00'),
(8424, 243, '36920', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'reistkri', '2023-06-01', '2038-12-30', '0.15', '6', 0, 3722, 3208, 0, 0, 6930, 6930, 9272, 9342, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6328', '2', 'W-6385', '0000-00-00', '0000-00-00'),
(8425, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'reistkri', '2023-06-01', '2038-12-30', '0.60', '6', 0, 14886, 12834, 0, 0, 27720, 27720, 37089, 37367, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6328', '3', 'W-6385', '0000-00-00', '0000-00-00'),
(8427, 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', 'neni', 0, 1, 'W-6330', '1', 'W-6393', '0000-00-00', '0000-00-00'),
(8428, 91, '36960', '888', '8889701V000', '9NN', 'Režie - ostatní', 'kuzmimic', '2023-06-01', '2038-12-30', '0.25', '6', 0, 8692, 6208, 0, 0, 14900, 14900, 19936, 20085, 59600, '', 'ne', 'ne', 'neni', 0, 1, 'W-6330', '2', 'W-6393', '0000-00-00', '0000-00-00'),
(8429, 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', 'neni', 0, 1, 'W-6330', '3', 'W-6393', '0000-00-00', '0000-00-00'),
(8430, 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', 'neni', 0, 1, 'W-6330', '4', 'W-6393', '0000-00-00', '0000-00-00'),
(8431, 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', 'neni', 0, 1, 'W-6330', '5', 'W-6393', '0000-00-00', '0000-00-00'),
(8541, 157, '36222', '661', '6612001V000', '1ND', 'EUKI - Energy Efficiency Network', 'mydlipet', '2023-06-01', '2038-12-30', '0.40', '6', 0, 9924, 13916, 0, 0, 23840, 23840, 31898, 32136, 59600, '', 'ne', 'ne', 'neni', 0, 1, 'W-6360', '1', 'W-6389', '0000-00-00', '0000-00-00'),
(8542, 231, '36222', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'mydlipet', '2023-06-01', '2038-12-30', '0.30', '6', 0, 7443, 10437, 0, 0, 17880, 17880, 23923, 24102, 59600, '', 'ne', 'ne', 'neni', 0, 1, 'W-6360', '2', 'W-6389', '0000-00-00', '0000-00-00'),
(8543, 232, '36222', '311', '3112203V000', '1ND', 'TAČR THETA IV - tribo-RVE (Šlechta)', 'mydlipet', '2023-06-01', '2038-12-30', '0.30', '6', 0, 7443, 10437, 0, 0, 17880, 17880, 23923, 24102, 59600, '', 'ne', 'ne', 'neni', 0, 1, 'W-6360', '3', 'W-6389', '0000-00-00', '0000-00-00'),
(8556, 157, '36222', '661', '6612001V000', '1ND', 'EUKI - Energy Efficiency Network', 'suchndan', '2023-06-01', '2038-12-30', '0.15', '6', 0, 3722, 3509, 0, 0, 7230, 7230, 9674, 9746, 48200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6364', '1', 'W-6390', '0000-00-00', '0000-00-00'),
(8557, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'suchndan', '2023-06-01', '2038-12-30', '0.40', '6', 0, 9924, 9356, 0, 0, 19280, 19280, 25797, 25989, 48200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6364', '2', 'W-6390', '0000-00-00', '0000-00-00'),
(8558, 230, '36222', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'suchndan', '2023-06-01', '2038-12-30', '0.35', '6', 0, 8684, 8187, 0, 0, 16870, 16870, 22572, 22741, 48200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6364', '3', 'W-6390', '0000-00-00', '0000-00-00'),
(8559, 325, '36222', '312', '3122301V000', '1ND', 'EE1 TAČR Théta V - Maščuch', 'suchndan', '2023-06-01', '2038-12-30', '0.10', '6', 0, 2481, 2339, 0, 0, 4820, 4820, 6449, 6497, 48200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6364', '4', 'W-6390', '0000-00-00', '0000-00-00'),
(8560, 157, '36222', '661', '6612001V000', '1ND', 'EUKI - Energy Efficiency Network', 'santijir', '2023-06-01', '2038-12-30', '0.30', '6', 0, 7443, 8397, 0, 0, 15840, 15840, 21194, 21352, 52800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6365', '1', 'W-6391', '0000-00-00', '0000-00-00'),
(8561, 230, '36222', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'santijir', '2023-06-01', '2038-12-30', '0.35', '6', 0, 8684, 9797, 0, 0, 18480, 18480, 24726, 24911, 52800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6365', '2', 'W-6391', '0000-00-00', '0000-00-00'),
(8562, 325, '36222', '312', '3122301V000', '1ND', 'EE1 TAČR Théta V - Maščuch', 'santijir', '2023-06-01', '2038-12-30', '0.35', '6', 0, 8684, 9797, 0, 0, 18480, 18480, 24726, 24911, 52800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6365', '3', 'W-6391', '0000-00-00', '0000-00-00'),
(8576, 157, '36222', '661', '6612001V000', '1ND', 'EUKI - Energy Efficiency Network', 'zelenzby', '2023-06-01', '2038-12-30', '0.20', '6', 0, 4962, 5498, 0, 0, 10460, 10460, 13995, 14100, 52300, '', 'ne', 'ne', 'neni', 0, 1, 'W-6368', '1', 'W-6392', '0000-00-00', '0000-00-00'),
(8577, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'zelenzby', '2023-06-01', '2038-12-30', '0.10', '6', 0, 2481, 2749, 0, 0, 5230, 5230, 6998, 7050, 52300, '', 'ne', 'ne', 'neni', 0, 1, 'W-6368', '2', 'W-6392', '0000-00-00', '0000-00-00'),
(8578, 90, '36222', '312', '3122002V000', '1ND', 'TAČR THETA III Data4energy', 'zelenzby', '2023-06-01', '2038-12-30', '0.15', '6', 0, 3722, 4124, 0, 0, 7845, 7845, 10497, 10575, 52300, '', 'ne', 'ne', 'neni', 0, 1, 'W-6368', '3', 'W-6392', '0000-00-00', '0000-00-00'),
(8579, 230, '36222', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'zelenzby', '2023-06-01', '2038-12-30', '0.05', '6', 0, 1241, 1375, 0, 0, 2615, 2615, 3499, 3525, 52300, '', 'ne', 'ne', 'neni', 0, 1, 'W-6368', '4', 'W-6392', '0000-00-00', '0000-00-00'),
(8580, 232, '36222', '311', '3112203V000', '1ND', 'TAČR THETA IV - tribo-RVE (Šlechta)', 'zelenzby', '2023-06-01', '2038-12-30', '0.20', '6', 0, 4962, 5498, 0, 0, 10460, 10460, 13995, 14100, 52300, '', 'ne', 'ne', 'neni', 0, 1, 'W-6368', '5', 'W-6392', '0000-00-00', '0000-00-00'),
(8581, 325, '36222', '312', '3122301V000', '1ND', 'EE1 TAČR Théta V - Maščuch', 'zelenzby', '2023-06-01', '2038-12-30', '0.30', '6', 0, 7443, 8247, 0, 0, 15690, 15690, 20993, 21150, 52300, '', 'ne', 'ne', 'neni', 0, 1, 'W-6368', '6', 'W-6392', '0000-00-00', '0000-00-00'),
(8623, 157, '36920', '661', '6612001V000', '1ND', 'EUKI - Energy Efficiency Network', 'stoladan', '2023-06-01', '2038-12-30', '0.12', '6', 0, 3126, 2418, 0, 0, 5544, 5544, 7418, 7473, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6386', '1', 'W-6387', '0000-00-00', '0000-00-00'),
(8624, 167, '36920', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'stoladan', '2023-06-01', '2038-12-30', '0.05', '6', 0, 1303, 1008, 0, 0, 2310, 2310, 3091, 3114, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6386', '2', 'W-6387', '0000-00-00', '0000-00-00'),
(8625, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'stoladan', '2023-06-01', '2038-12-30', '0.83', '6', 0, 21622, 16725, 0, 0, 38346, 38346, 51307, 51690, 46200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6386', '3', 'W-6387', '0000-00-00', '0000-00-00'),
(8653, 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', 'neni', 0, 0, 'W-6393', '1', 'W-6394', '0000-00-00', '0000-00-00'),
(8654, 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', 'neni', 0, 0, 'W-6393', '2', 'W-6394', '0000-00-00', '0000-00-00'),
(8655, 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', 'neni', 0, 0, 'W-6393', '3', 'W-6394', '0000-00-00', '0000-00-00'),
(8656, 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', 'neni', 0, 0, 'W-6393', '4', 'W-6394', '0000-00-00', '0000-00-00'),
(8657, 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', 'neni', 0, 0, 'W-6393', '5', 'W-6394', '0000-00-00', '0000-00-00'),
(8727, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'spaleja1', '2023-07-01', '2038-12-30', '0.05', '6', 0, 1241, 1259, 0, 0, 2500, 2500, 3345, 3370, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6417', '1', 'W-6826', '0000-00-00', '0000-00-00'),
(8728, 230, '36222', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'spaleja1', '2023-07-01', '2038-12-30', '0.05', '6', 0, 1241, 1259, 0, 0, 2500, 2500, 3345, 3370, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6417', '2', 'W-6826', '0000-00-00', '0000-00-00'),
(8729, 231, '36222', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'spaleja1', '2023-07-01', '2038-12-30', '0.15', '6', 0, 3723, 3777, 0, 0, 7500, 7500, 10035, 10110, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6417', '3', 'W-6826', '0000-00-00', '0000-00-00'),
(8730, 325, '36222', '312', '3122301V000', '1ND', 'EE1 TAČR Théta V - Maščuch', 'spaleja1', '2023-07-01', '2038-12-30', '0.35', '6', 0, 8687, 8813, 0, 0, 17500, 17500, 23415, 23590, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6417', '4', 'W-6826', '0000-00-00', '0000-00-00'),
(8788, 267, '36255', '301', '3012301V000', '1ND', 'Bytová družstva GAČR Polsko - Vácha', 'belchwoj', '2023-08-01', '2038-12-30', '0.20', '6', 0, 4962, 7038, 0, 0, 12000, 12000, 16056, 16176, 60000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6442', '1', 'W-6444', '0000-00-00', '0000-00-00'),
(8789, 270, '36255', '311', '3112207V000', '1ND', 'TAČR BETA - Energetické komunity - Vácha', 'belchwoj', '2023-08-01', '2038-12-30', '0.50', '6', 0, 12405, 17595, 3750, 0, 33750, 30000, 45158, 45495, 60000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6442', '2', 'W-6444', '0000-00-00', '0000-00-00'),
(8790, 242, '36255', '311', '3112202B001', '1ND', 'TAČR THETA IV - Power2Heat', 'belchwoj', '2023-08-01', '2038-12-30', '0.10', '6', 0, 2481, 3519, 750, 0, 6750, 6000, 9032, 9099, 60000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6442', '3', 'W-6444', '0000-00-00', '0000-00-00'),
(8791, 303, '36255', '606', '6062301V000', '1ND', 'GLocalFlex HE - Zavřel', 'belchwoj', '2023-08-01', '2038-12-30', '0.20', '6', 0, 4962, 7038, 1500, 0, 13500, 12000, 18063, 18198, 60000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6442', '4', 'W-6444', '0000-00-00', '0000-00-00'),
(8803, 383, '36231', '261', '2612306A124', '1ND', 'NAKI MKČR - Maierová', 'xhavlikj', '2023-09-01', '2024-12-31', '0.20', 'A3', 0, 5530, 4470, 0, 0, 10000, 10000, 13380, 13480, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6446', '1', 'W-6469', '0000-00-00', '0000-00-00'),
(8804, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'zuzansch', '2023-09-01', '2023-12-31', '1.00', '6', 0, 24810, 20190, 0, 0, 45000, 45000, 60210, 60660, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6448', '1', 'W-6525', '0000-00-00', '0000-00-00'),
(8816, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'mydlipet', '2023-08-01', '2038-12-30', '0.05', '6', 0, 1241, 1740, 0, 0, 2980, 2980, 3987, 4017, 59600, '', 'ne', 'ne', 'neni', 0, 1, 'W-6453', '1', 'W-6462', '0000-00-00', '0000-00-00'),
(8817, 231, '36222', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'mydlipet', '2023-08-01', '2038-12-30', '0.40', '6', 0, 9924, 13916, 0, 0, 23840, 23840, 31898, 32136, 59600, '', 'ne', 'ne', 'neni', 0, 1, 'W-6453', '2', 'W-6462', '0000-00-00', '0000-00-00'),
(8818, 232, '36222', '311', '3112203V000', '1ND', 'TAČR THETA IV - tribo-RVE (Šlechta)', 'mydlipet', '2023-08-01', '2038-12-30', '0.30', '6', 0, 7443, 10437, 0, 0, 17880, 17880, 23923, 24102, 59600, '', 'ne', 'ne', 'neni', 0, 1, 'W-6453', '3', 'W-6462', '0000-00-00', '0000-00-00'),
(8819, 325, '36222', '312', '3122301V000', '1ND', 'EE1 TAČR Théta V - Maščuch', 'mydlipet', '2023-08-01', '2038-12-30', '0.10', '6', 0, 2481, 3479, 0, 0, 5960, 5960, 7974, 8034, 59600, '', 'ne', 'ne', 'neni', 0, 1, 'W-6453', '4', 'W-6462', '0000-00-00', '0000-00-00'),
(8820, 452, '36222', '398', '3142302B062', '1ND', 'NCE 2 TAČR - Maščuch', 'mydlipet', '2023-08-01', '2038-12-30', '0.15', '6', 0, 3722, 5219, 0, 0, 8940, 8940, 11962, 12051, 59600, '', 'ne', 'ne', 'neni', 0, 1, 'W-6453', '5', 'W-6462', '0000-00-00', '0000-00-00'),
(8826, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'simanm11', '2023-08-01', '2038-12-30', '0.40', '4', 0, 8604, 9396, 0, 0, 18000, 18000, 24084, 24264, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6455', '1', 'W-6463', '0000-00-00', '0000-00-00'),
(8827, 90, '36222', '312', '3122002V000', '1ND', 'TAČR THETA III Data4energy', 'simanm11', '2023-08-01', '2038-12-30', '0.05', '4', 0, 1076, 1175, 0, 0, 2250, 2250, 3011, 3033, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6455', '2', 'W-6463', '0000-00-00', '0000-00-00'),
(8828, 230, '36222', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'simanm11', '2023-08-01', '2038-12-30', '0.45', '4', 0, 9680, 10571, 0, 0, 20250, 20250, 27095, 27297, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6455', '3', 'W-6463', '0000-00-00', '0000-00-00'),
(8829, 232, '36222', '311', '3112203V000', '1ND', 'TAČR THETA IV - tribo-RVE (Šlechta)', 'simanm11', '2023-08-01', '2038-12-30', '0.10', '4', 0, 2151, 2349, 0, 0, 4500, 4500, 6021, 6066, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6455', '4', 'W-6463', '0000-00-00', '0000-00-00'),
(8836, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'santijir', '2023-08-01', '2038-12-30', '0.15', '6', 0, 3722, 4199, 0, 0, 7920, 7920, 10597, 10676, 52800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6457', '1', 'W-6461', '0000-00-00', '0000-00-00'),
(8837, 230, '36222', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'santijir', '2023-08-01', '2038-12-30', '0.30', '6', 0, 7443, 8397, 0, 0, 15840, 15840, 21194, 21352, 52800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6457', '2', 'W-6461', '0000-00-00', '0000-00-00'),
(8838, 325, '36222', '312', '3122301V000', '1ND', 'EE1 TAČR Théta V - Maščuch', 'santijir', '2023-08-01', '2038-12-30', '0.30', '6', 0, 7443, 8397, 0, 0, 15840, 15840, 21194, 21352, 52800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6457', '3', 'W-6461', '0000-00-00', '0000-00-00'),
(8839, 452, '36222', '398', '3142302B062', '1ND', 'NCE 2 TAČR - Maščuch', 'santijir', '2023-08-01', '2038-12-30', '0.25', '6', 0, 6203, 6998, 0, 0, 13200, 13200, 17662, 17794, 52800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6457', '4', 'W-6461', '0000-00-00', '0000-00-00'),
(8886, 167, '36255', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'stanknic', '2023-09-01', '2023-11-30', '0.05', '6', 0, 1241, 1110, 0, 0, 2350, 2350, 3144, 3168, 47000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6473', '1', 'W-6486', '0000-00-00', '0000-00-00'),
(8887, 270, '36255', '311', '3112207V000', '1ND', 'TAČR BETA - Energetické komunity - Vácha', 'stanknic', '2023-09-01', '2023-11-30', '0.44', '6', 0, 10916, 9764, 0, 0, 20680, 20680, 27670, 27877, 47000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6473', '2', 'W-6486', '0000-00-00', '0000-00-00'),
(8888, 267, '36255', '301', '3012301V000', '1ND', 'Bytová družstva GAČR Polsko - Vácha', 'stanknic', '2023-09-01', '2023-11-30', '0.01', '6', 0, 248, 222, 0, 0, 470, 470, 629, 634, 47000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6473', '3', 'W-6486', '0000-00-00', '0000-00-00'),
(8909, 311, '', '311', '3112301V000', '1ND', 'SAFEBATT- TAČR 4.VS - Dostál', 'dostaji4', '2023-10-01', '2038-12-30', '0.70', '6', 0, 17367, 28133, 7000, 0, 52500, 45500, 70245, 70770, 65000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6488', '1', 'W-6689', '0000-00-00', '0000-00-00'),
(8910, 303, '', '606', '6062301V000', '1ND', 'GLocalFlex HE - Zavřel', 'dostaji4', '2023-10-01', '2038-12-30', '0.30', '6', 0, 7443, 12057, 3000, 0, 22500, 19500, 30105, 30330, 65000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6488', '2', 'W-6689', '0000-00-00', '0000-00-00'),
(9073, 383, '36231', '261', '2612306A124', '1ND', 'NAKI MKČR - Maierová', 'xhavlikj', '2023-10-01', '2023-11-30', '0.15', 'A3', 0, 4148, 3353, 0, 0, 7500, 7500, 10035, 10110, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6470', '1', 'W-6873', '2023-10-01', '2024-12-31'),
(9074, 388, '36231', '312', '3122302V000', '1ND', 'LUNA TAČR Trend Nováčci - Maierová', 'xhavlikj', '2023-10-01', '2023-11-30', '0.05', 'A3', 0, 1383, 1117, 0, 0, 2500, 2500, 3345, 3370, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6470', '2', 'W-6873', '2023-10-01', '2024-12-31'),
(9078, 300, '36930', '591', '5912302V000', '1ND', 'Circular WEEP Interreg CE - Tobiáš', 'danickar', '2023-10-01', '2023-12-31', '0.60', '4', 0, 12906, 10494, 0, 0, 23400, 23400, 31309, 31543, 39000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6534', '1', 'W-6589', '0000-00-00', '0000-00-00'),
(9079, 310, '36930', '591', '5912301V000', '1ND', 'WEEEWaste - Interreg Europe - Tobiáš', 'danickar', '2023-10-01', '2023-12-31', '0.40', '4', 0, 8604, 6996, 0, 0, 15600, 15600, 20873, 21029, 39000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6534', '2', 'W-6589', '0000-00-00', '0000-00-00'),
(9088, 300, '36940', '591', '5912302V000', '1ND', 'Circular WEEP Interreg CE - Tobiáš', 'kuklipe1', '2023-10-01', '2038-12-30', '0.50', '6', 0, 17000, 16400, 0, 0, 33400, 33400, 44689, 45023, 66800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6542', '1', 'W-6575', '0000-00-00', '0000-00-00'),
(9089, 75, '36960', '604', '6041901V000', '1ND', 'H2020 - SPARCS', 'kuzmimic', '2023-10-01', '2038-12-30', '0.45', '6', 0, 18000, 13590, 0, 0, 31590, 31590, 42267, 42583, 70200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6543', '1', 'W-6572', '0000-00-00', '0000-00-00'),
(9090, 91, '36960', '888', '8889701V000', '9NN', 'Režie - ostatní', 'kuzmimic', '2023-10-01', '2038-12-30', '0.25', '6', 0, 10000, 7550, 0, 0, 17550, 17550, 23482, 23657, 70200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6543', '2', 'W-6572', '0000-00-00', '0000-00-00'),
(9091, 242, '36960', '311', '3112202B001', '1ND', 'TAČR THETA IV - Power2Heat', 'kuzmimic', '2023-10-01', '2038-12-30', '0.10', '6', 0, 4000, 3020, 0, 0, 7020, 7020, 9393, 9463, 70200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6543', '3', 'W-6572', '0000-00-00', '0000-00-00'),
(9092, 263, '36960', '606', '6062202V000', '1ND', 'CRAFT HE - Vácha', 'kuzmimic', '2023-10-01', '2038-12-30', '0.10', '6', 0, 4000, 3020, 0, 0, 7020, 7020, 9393, 9463, 70200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6543', '4', 'W-6572', '0000-00-00', '0000-00-00'),
(9093, 272, '36960', '606', '6062201V000', '1ND', 'NEB-STAR HE - Kuzmič', 'kuzmimic', '2023-10-01', '2038-12-30', '0.10', '6', 0, 4000, 3020, 0, 0, 7020, 7020, 9393, 9463, 70200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6543', '5', 'W-6572', '0000-00-00', '0000-00-00'),
(9094, 310, '36920', '591', '5912301V000', '1ND', 'WEEEWaste - Interreg Europe - Tobiáš', 'holecste', '2023-10-01', '2038-12-30', '0.68', '6', 0, 16864, 16388, 0, 0, 33252, 33252, 44491, 44824, 48900, '', 'ne', 'ne', 'neni', 0, 1, 'W-6544', '1', 'W-6578', '0000-00-00', '0000-00-00'),
(9095, 270, '36920', '311', '3112207V000', '1ND', 'TAČR BETA - Energetické komunity - Vácha', 'holecste', '2023-10-01', '2038-12-30', '0.06', '6', 0, 1488, 1446, 0, 0, 2934, 2934, 3926, 3955, 48900, '', 'ne', 'ne', 'neni', 0, 1, 'W-6544', '2', 'W-6578', '0000-00-00', '0000-00-00'),
(9096, 267, '36920', '301', '3012301V000', '1ND', 'Bytová družstva GAČR Polsko - Vácha', 'holecste', '2023-10-01', '2038-12-30', '0.14', '6', 0, 3472, 3374, 0, 0, 6846, 6846, 9160, 9228, 48900, '', 'ne', 'ne', 'neni', 0, 1, 'W-6544', '3', 'W-6578', '0000-00-00', '0000-00-00'),
(9097, 300, '36920', '591', '5912302V000', '1ND', 'Circular WEEP Interreg CE - Tobiáš', 'holecste', '2023-10-01', '2038-12-30', '0.12', '6', 0, 2976, 2892, 0, 0, 5868, 5868, 7851, 7910, 48900, '', 'ne', 'ne', 'neni', 0, 1, 'W-6544', '5', 'W-6578', '0000-00-00', '0000-00-00'),
(9105, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'pospika4', '2023-10-01', '2038-12-30', '1.00', '6', 0, 24800, 24200, 0, 0, 49000, 49000, 65562, 66052, 49000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6550', '1', 'W-6638', '0000-00-00', '0000-00-00'),
(9109, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'rutovmar', '2023-10-01', '2023-12-31', '0.50', '6', 0, 12405, 9845, 0, 0, 22250, 22250, 29771, 29993, 44500, '', 'ne', 'ne', 'neni', 0, 1, 'W-6552', '1', 'W-6646', '0000-00-00', '0000-00-00'),
(9110, 310, '36920', '591', '5912301V000', '1ND', 'WEEEWaste - Interreg Europe - Tobiáš', 'rutovmar', '2023-10-01', '2023-12-31', '0.50', '6', 0, 12405, 9845, 0, 0, 22250, 22250, 29771, 29993, 44500, '', 'ne', 'ne', 'neni', 0, 1, 'W-6552', '2', 'W-6646', '0000-00-00', '0000-00-00'),
(9111, 91, '36910', '888', '8889701V000', '9NN', 'Režie - ostatní', 'seibejan', '2023-10-01', '2023-12-31', '1.00', '6', 0, 39000, 34700, 0, 0, 73700, 73700, 98611, 99348, 73700, '', 'ne', 'ne', 'neni', 0, 1, 'W-6553', '1', 'W-6588', '0000-00-00', '0000-00-00'),
(9116, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'spickma2', '2023-10-01', '2023-12-31', '1.00', '4', 0, 25000, 22200, 0, 0, 47200, 47200, 63154, 63626, 47200, '', 'ne', 'ne', 'neni', 0, 1, 'W-6556', '1', 'W-6590', '0000-00-00', '0000-00-00'),
(9120, 272, '36960', '606', '6062201V000', '1ND', 'NEB-STAR HE - Kuzmič', 'civinjan', '2023-10-01', '2038-12-30', '0.35', '6', 0, 8684, 8116, 0, 0, 16800, 16800, 22478, 22646, 48000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6559', '1', 'W-6573', '0000-00-00', '0000-00-00'),
(9121, 304, '36960', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'civinjan', '2023-10-01', '2038-12-30', '0.35', '6', 0, 8684, 8116, 0, 0, 16800, 16800, 22478, 22646, 48000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6559', '2', 'W-6573', '0000-00-00', '0000-00-00'),
(9126, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'zuzansch', '2023-10-01', '2023-12-31', '0.64', '6', 0, 15878, 13882, 0, 0, 29760, 29760, 39819, 40116, 46500, '', 'ne', 'ne', 'neni', 0, 1, 'W-6562', '1', 'W-6668', '0000-00-00', '0000-00-00'),
(9127, 230, '36920', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'zuzansch', '2023-10-01', '2023-12-31', '0.14', '6', 0, 3473, 3037, 0, 0, 6510, 6510, 8710, 8775, 46500, '', 'ne', 'ne', 'neni', 0, 1, 'W-6562', '2', 'W-6668', '0000-00-00', '0000-00-00'),
(9128, 225, '36920', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'zuzansch', '2023-10-01', '2023-12-31', '0.22', '6', 0, 5458, 4772, 0, 0, 10230, 10230, 13688, 13790, 46500, '', 'ne', 'ne', 'neni', 0, 1, 'W-6562', '3', 'W-6668', '0000-00-00', '0000-00-00'),
(9129, 86, '36870', '888', '8888100V000', '9NN', 'Režie - správa budovy', 'smrcklu2', '2023-10-01', '2023-12-31', '0.50', '1', 0, 8650, 8350, 0, 500, 17500, 17000, 23415, 23590, 34000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6563', '1', 'W-6592', '0000-00-00', '0000-00-00'),
(9130, 112, '36920', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'tomeska1', '2023-10-01', '2038-12-30', '0.05', '6', 0, 2000, 1790, 0, 100, 3890, 3790, 5205, 5244, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6564', '1', 'W-6657', '0000-00-00', '0000-00-00'),
(9131, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'tomeska1', '2023-10-01', '2038-12-30', '0.42', '6', 0, 16800, 15036, 0, 840, 32676, 31836, 43720, 44047, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6564', '2', 'W-6657', '0000-00-00', '0000-00-00'),
(9132, 311, '36920', '311', '3112301V000', '1ND', 'SAFEBATT- TAČR 4.VS - Dostál', 'tomeska1', '2023-10-01', '2038-12-30', '0.17', '6', 0, 6800, 6086, 0, 340, 13226, 12886, 17696, 17829, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6564', '3', 'W-6657', '0000-00-00', '0000-00-00'),
(9133, 231, '36920', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'tomeska1', '2023-10-01', '2038-12-30', '0.09', '6', 0, 3600, 3222, 0, 180, 7002, 6822, 9369, 9439, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6564', '4', 'W-6657', '0000-00-00', '0000-00-00'),
(9134, 232, '36920', '311', '3112203V000', '1ND', 'TAČR THETA IV - tribo-RVE (Šlechta)', 'tomeska1', '2023-10-01', '2038-12-30', '0.07', '6', 0, 2800, 2506, 0, 140, 5446, 5306, 7287, 7341, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6564', '5', 'W-6657', '0000-00-00', '0000-00-00'),
(9135, 470, '36920', '606', '6062304V007', '1ND', 'NBSINFRA HE-Sněhota - WP7', 'tomeska1', '2023-10-01', '2038-12-30', '0.04', '6', 0, 1600, 1432, 0, 80, 3112, 3032, 4164, 4195, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6564', '6', 'W-6657', '0000-00-00', '0000-00-00'),
(9136, 302, '36920', '606', '6062303V000', '1ND', 'CIRC-BOOST HE - Pavlů', 'tomeska1', '2023-10-01', '2038-12-30', '0.16', '6', 0, 6400, 5728, 0, 320, 12448, 12128, 16655, 16780, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6564', '7', 'W-6657', '0000-00-00', '0000-00-00'),
(9154, 75, '36960', '604', '6041901V000', '1ND', 'H2020 - SPARCS', 'civinjan', '2023-10-01', '2038-12-30', '0.50', '6', 0, 12406, 11594, 0, 0, 24000, 24000, 32112, 32352, 48000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6573', '1', 'W-6596', '0000-00-00', '0000-00-00'),
(9155, 304, '36960', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'civinjan', '2023-10-01', '2038-12-30', '0.20', '6', 0, 4962, 4638, 0, 0, 9600, 9600, 12845, 12941, 48000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6573', '2', 'W-6596', '0000-00-00', '0000-00-00'),
(9156, 300, '36940', '591', '5912302V000', '1ND', 'Circular WEEP Interreg CE - Tobiáš', 'kuklipe1', '2023-10-01', '2023-12-31', '0.40', '6', 0, 13600, 13120, 0, 0, 26720, 26720, 35751, 36019, 66800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6575', '1', 'W-6591', '0000-00-00', '0000-00-00'),
(9157, 91, '36940', '888', '8889701V000', '9NN', 'Režie - ostatní', 'kuklipe1', '2023-10-01', '2023-12-31', '0.10', '6', 0, 3400, 3280, 0, 0, 6680, 6680, 8938, 9005, 66800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6575', '2', 'W-6591', '0000-00-00', '0000-00-00'),
(9158, 128, '36216', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'trubinik', '2023-10-01', '2023-12-31', '0.65', '6', 0, 16127, 8911, 0, 0, 25038, 25038, 33501, 33751, 38520, '', 'ne', 'ne', 'neni', 0, 1, 'W-6577', '1', 'W-6613', '0000-00-00', '0000-00-00'),
(9159, 279, '36216', '661', '6612202V000', '1ND', 'Cir4ConClimate EUKI - Pavlů', 'trubinik', '2023-10-01', '2023-12-31', '0.10', '6', 0, 2481, 1371, 0, 0, 3852, 3852, 5154, 5192, 38520, '', 'ne', 'ne', 'neni', 0, 1, 'W-6577', '2', 'W-6613', '0000-00-00', '0000-00-00'),
(9165, 270, '36255', '311', '3112207V000', '1ND', 'TAČR BETA - Energetické komunity - Vácha', 'neslamic', '2023-10-01', '2038-12-30', '1.00', '6', 0, 24810, 20190, 8000, 0, 53000, 45000, 70914, 71444, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6583', '1', 'W-6618', '0000-00-00', '0000-00-00'),
(9168, 270, '36254', '311', '3112207V000', '1ND', 'TAČR BETA - Energetické komunity - Vácha', 'wolfp1', '2023-10-01', '2023-10-31', '1.00', '7', 0, 27650, 35350, 32000, 0, 95000, 63000, 127110, 128060, 63000, '', 'ne', 'ne', 'neni', 0, 0, 'W-6585', '1', 'W-6586', '0000-00-00', '0000-00-00'),
(9190, 128, '36910', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'lupisant', '2023-11-01', '2038-12-30', '0.19', 'A4', 0, 12350, 11856, 0, 0, 24206, 24206, 32388, 32630, 127400, '', 'ne', 'ne', 'neni', 0, 1, 'W-6600', '1', 'W-6778', '0000-00-00', '0000-00-00'),
(9191, 208, '36910', '604', '6042201V000', '1ND', 'H2020 - ARV', 'lupisant', '2023-11-01', '2038-12-30', '0.20', 'A4', 0, 13000, 12480, 0, 0, 25480, 25480, 34092, 34347, 127400, '', 'ne', 'ne', 'neni', 0, 1, 'W-6600', '2', 'W-6778', '0000-00-00', '0000-00-00'),
(9192, 91, '36910', '888', '8889701V000', '9NN', 'Režie - ostatní', 'lupisant', '2023-11-01', '2038-12-30', '0.51', 'A4', 0, 33150, 31824, 0, 0, 64974, 64974, 86935, 87585, 127400, '', 'ne', 'ne', 'neni', 0, 1, 'W-6600', '3', 'W-6778', '0000-00-00', '0000-00-00'),
(9218, 128, '36216', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'trubinik', '2023-11-01', '2024-12-31', '0.65', '6', 0, 16127, 8911, 0, 0, 25038, 25038, 33501, 33751, 38520, '', 'ne', 'ne', 'neni', 0, 1, 'W-6615', '1', 'W-6624', '0000-00-00', '0000-00-00'),
(9219, 279, '36216', '661', '6612202V000', '1ND', 'Cir4ConClimate EUKI - Pavlů', 'trubinik', '2023-11-01', '2024-12-31', '0.10', '6', 0, 2481, 1371, 0, 0, 3852, 3852, 5154, 5192, 38520, '', 'ne', 'ne', 'neni', 0, 1, 'W-6615', '2', 'W-6624', '0000-00-00', '0000-00-00'),
(9275, 112, '36920', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'tomeska1', '2023-10-01', '2038-12-30', '0.05', '6', 0, 2000, 1790, 0, 100, 3890, 3790, 5205, 5244, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6657', '1', 'W-6661', '0000-00-00', '0000-00-00'),
(9276, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'tomeska1', '2023-10-01', '2038-12-30', '0.22', '6', 0, 8800, 7876, 0, 440, 17116, 16676, 22901, 23072, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6657', '2', 'W-6661', '0000-00-00', '0000-00-00'),
(9277, 311, '36920', '311', '3112301V000', '1ND', 'SAFEBATT- TAČR 4.VS - Dostál', 'tomeska1', '2023-10-01', '2038-12-30', '0.17', '6', 0, 6800, 6086, 0, 340, 13226, 12886, 17696, 17829, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6657', '3', 'W-6661', '0000-00-00', '0000-00-00'),
(9278, 231, '36920', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'tomeska1', '2023-10-01', '2038-12-30', '0.09', '6', 0, 3600, 3222, 0, 180, 7002, 6822, 9369, 9439, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6657', '4', 'W-6661', '0000-00-00', '0000-00-00'),
(9279, 232, '36920', '311', '3112203V000', '1ND', 'TAČR THETA IV - tribo-RVE (Šlechta)', 'tomeska1', '2023-10-01', '2038-12-30', '0.07', '6', 0, 2800, 2506, 0, 140, 5446, 5306, 7287, 7341, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6657', '5', 'W-6661', '0000-00-00', '0000-00-00'),
(9280, 470, '36920', '606', '6062304V007', '1ND', 'NBSINFRA HE-Sněhota - WP7', 'tomeska1', '2023-10-01', '2038-12-30', '0.04', '6', 0, 1600, 1432, 0, 80, 3112, 3032, 4164, 4195, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6657', '6', 'W-6661', '0000-00-00', '0000-00-00'),
(9281, 302, '36920', '606', '6062303V000', '1ND', 'CIRC-BOOST HE - Pavlů', 'tomeska1', '2023-10-01', '2038-12-30', '0.16', '6', 0, 6400, 5728, 0, 320, 12448, 12128, 16655, 16780, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6657', '7', 'W-6661', '0000-00-00', '0000-00-00'),
(9282, 208, '36920', '604', '6042201V000', '1ND', 'H2020 - ARV', 'tomeska1', '2023-10-01', '2038-12-30', '0.20', '6', 0, 8000, 7160, 0, 400, 15560, 15160, 20819, 20975, 75800, '', 'ne', 'ne', 'neni', 0, 1, 'W-6657', '8', 'W-6661', '0000-00-00', '0000-00-00'),
(9335, 311, '', '311', '3112301V000', '1ND', 'SAFEBATT- TAČR 4.VS - Dostál', 'dostaji4', '2023-10-01', '2038-12-30', '0.70', '6', 0, 17367, 28133, 7000, 0, 52500, 45500, 70245, 70770, 65000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6689', '1', 'W-6690', '0000-00-00', '0000-00-00'),
(9336, 303, '', '606', '6062301V000', '1ND', 'GLocalFlex HE - Zavřel', 'dostaji4', '2023-10-01', '2038-12-30', '0.30', '6', 0, 7443, 12057, 3000, 0, 22500, 19500, 30105, 30330, 65000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6689', '2', 'W-6690', '0000-00-00', '0000-00-00'),
(9357, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'stoladan', '2023-11-01', '2038-12-30', '0.75', '6', 0, 19538, 17212, 0, 0, 36750, 36750, 49172, 49539, 49000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6709', '1', 'W-6779', '0000-00-00', '0000-00-00'),
(9358, 167, '36920', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'stoladan', '2023-11-01', '2038-12-30', '0.05', '6', 0, 1303, 1147, 0, 0, 2450, 2450, 3278, 3303, 49000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6709', '2', 'W-6779', '0000-00-00', '0000-00-00'),
(9359, 385, '36920', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'stoladan', '2023-11-01', '2038-12-30', '0.20', '6', 0, 5210, 4590, 0, 0, 9800, 9800, 13112, 13210, 49000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6709', '3', 'W-6779', '0000-00-00', '0000-00-00'),
(9370, 117, '36241', '302', '3022101V000', '1ND', 'GAČR - LEFM', 'velebluk', '2023-11-01', '2038-12-30', '0.10', 'A3', 0, 3100, 1900, 0, 0, 5000, 5000, 6690, 6740, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6713', '1', 'W-6772', '0000-00-00', '0000-00-00'),
(9371, 385, '36241', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'velebluk', '2023-11-01', '2038-12-30', '0.40', 'A3', 0, 12400, 7600, 0, 0, 20000, 20000, 26760, 26960, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6713', '2', 'W-6772', '0000-00-00', '0000-00-00'),
(9372, 250, '36241', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'matejsi2', '2023-12-01', '2024-12-31', '0.20', '5', 0, 4670, 4330, 0, 0, 9000, 9000, 12042, 12132, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6714', '1', 'W-6825', '0000-00-00', '0000-00-00'),
(9373, 385, '36241', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'matejsi2', '2023-12-01', '2024-12-31', '0.40', '5', 0, 9340, 8660, 0, 0, 18000, 18000, 24084, 24264, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-6714', '2', 'W-6825', '0000-00-00', '0000-00-00'),
(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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 1, 'W-6752', '4', 'W-6761', '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`, `stav`, `idAplikace`, `idAplikace2`, `idAplikaceKteraZpusobilaZmenu`, `puvodni_na_projektu_od`, `puvodni_na_projektu_do`) VALUES
(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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 1, 'W-6781', '4', 'W-6942', '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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 1, 'W-6807', '6', 'W-6831', '0000-00-00', '0000-00-00'),
(9690, 199, '36212', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'XXXtmpXXXbeckajir', '2024-01-01', '2025-12-31', '0.20', '6', 0, 4962, 2638, 0, 0, 7600, 7600, 10169, 10245, 38000, '', 'ne', 'ne', 'neni', 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, 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, 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, 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, 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, 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, '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, '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, '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, '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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 1, 'W-6844', '3', 'W-6859', '0000-00-00', '0000-00-00'),
(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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 1, 'W-6923', '3', 'W-6945', '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č',
  `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`, `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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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', 'XXXtmpXXXsvoboto9', '2022-10-01', '2023-05-31', '1.00', '6', 0, 30000, 25000, 0, 0, 55000, 55000, 73590, 74140, 55000, '', 'ne', 'ne', '', NULL, 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, '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, '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, '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, '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, '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, '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, '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, 'W-6394', '5', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(10227, 263, '36216', '606', '6062202V000', '1ND', 'CRAFT HE - Vácha', 'kmonibar', '2024-01-01', '2024-12-31', '0.25', '7', 0, 6912, 4901, 0, 0, 11813, 11813, 15806, 15924, 47250, '', 'ne', 'ne', '', NULL, 0, 'W-6950', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(10228, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'kmonibar', '2024-01-01', '2024-12-31', '0.05', '7', 0, 1382, 980, 0, 0, 2363, 2363, 3162, 3185, 47250, '', 'ne', 'ne', '', NULL, 0, 'W-6950', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(10229, 467, '36216', '606', '6062304V002', '1ND', 'NBSINFRA HE-Sněhota - WP2', 'kmonibar', '2024-01-01', '2024-12-31', '0.10', '7', 0, 2765, 1960, 0, 0, 4725, 4725, 6322, 6369, 47250, '', 'ne', 'ne', '', NULL, 0, 'W-6950', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(10230, 272, '36216', '606', '6062201V000', '1ND', 'NEB-STAR HE - Kuzmič', 'kmonibar', '2024-01-01', '2024-12-31', '0.40', '7', 0, 11059, 7841, 0, 0, 18900, 18900, 25288, 25477, 47250, '', 'ne', 'ne', '', NULL, 0, 'W-6950', '4', '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, '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, '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, 'W-6954', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(10253, 128, '36216', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'trubinik', '2024-01-01', '2024-12-31', '1.00', '6', 0, 24811, 13709, 0, 0, 38520, 38520, 51540, 51925, 38520, '', 'ne', 'ne', '', NULL, 0, 'W-6961', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(10254, 385, '36213', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'vancuto4', '2024-01-01', '2024-12-31', '0.20', '6', 0, 5000, 3400, 0, 0, 8400, 8400, 11239, 11323, 42000, '', 'ne', 'ne', '', NULL, 0, 'W-6962', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(10255, 199, '36213', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'vancuto4', '2024-01-01', '2024-12-31', '0.80', '6', 0, 20000, 13600, 0, 0, 33600, 33600, 44957, 45293, 42000, '', 'ne', 'ne', '', NULL, 0, 'W-6962', '2', '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 `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_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=3766;

--
-- 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=1166;

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

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

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

--
-- 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=10256;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
