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
(5693, 177, '36221', '552', '5522108V000', '1ND', 'OP PIK ALTEKO Zmrhal', 'kucermir', '2022-07-01', '2022-12-31', '0.20', 'A3', 0, 6200, 3800, 0, 0, 10000, 10000, 13380, 13480, 50000, '', 'ne', '', 'neni', 0, 1, 'W-5102', '3', 'W-5233', '0000-00-00', '0000-00-00'),
(5699, 74, '36216', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'vlasabar', '2022-06-01', '2038-12-30', '0.09', '6', 0, 2250, 2070, 0, 0, 4320, 4320, 5780, 5823, 48000, '', 'ne', '', 'neni', 0, 1, 'W-5106', '1', 'W-5168', '0000-00-00', '0000-00-00'),
(5700, 47, '36216', '165', '1651901V000', '1ND', 'MŠMT INTER TRANSFER Annex 72 - životní cyklus budov', 'vlasabar', '2022-06-01', '2038-12-30', '0.01', '6', 0, 250, 230, 0, 0, 480, 480, 642, 647, 48000, '', 'ne', '', 'neni', 0, 1, 'W-5106', '2', 'W-5168', '0000-00-00', '0000-00-00'),
(5701, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'vlasabar', '2022-06-01', '2038-12-30', '0.31', '6', 0, 7750, 7130, 0, 0, 14880, 14880, 19909, 20058, 48000, '', 'ne', '', 'neni', 0, 1, 'W-5106', '3', 'W-5168', '0000-00-00', '0000-00-00'),
(5702, 277, '36216', '113', '1132201V000', '1ND', 'UNILEAD MŠMT - CRP 2022', 'vlasabar', '2022-06-01', '2038-12-30', '0.59', '6', 0, 14750, 13570, 0, 0, 28320, 28320, 37892, 38175, 48000, '', 'ne', '', 'neni', 0, 1, 'W-5106', '4', 'W-5168', '0000-00-00', '0000-00-00'),
(5722, 75, '36960', '604', '6041901V000', '1ND', 'H2020 - SPARCS', 'kuzmimic', '2022-05-01', '2022-05-31', '0.55', '6', 0, 19122, 14318, 0, 0, 33440, 33440, 44743, 45077, 60800, '', 'ne', '', 'neni', 0, 1, 'W-5109', '1', 'W-5530', '2022-05-01', '2038-12-30'),
(5723, 179, '36960', '552', '5522103V000', '1ND', 'OP PIK Energocentrum II SCADA BI', 'kuzmimic', '2022-05-01', '2022-05-31', '0.25', '6', 0, 8520, 6380, 0, 0, 14900, 14900, 19936, 20085, 59600, '', 'ne', '', 'neni', 0, 1, 'W-5109', '2', 'W-5530', '2022-05-01', '2038-12-30'),
(5724, 91, '36960', '888', '8889701V000', '9NN', 'Režie - ostatní', 'kuzmimic', '2022-05-01', '2022-05-31', '0.10', '6', 0, 3543, 2653, 0, 0, 6196, 6196, 8290, 8352, 61955, '', 'ne', '', 'neni', 0, 1, 'W-5109', '3', 'W-5530', '2022-05-01', '2038-12-30'),
(5725, 263, '36960', '604', '6042202V000', '1ND', 'CRAFT HE - Vácha', 'kuzmimic', '2022-05-01', '2022-05-31', '0.10', '6', 0, 3543, 2653, 0, 0, 6196, 6196, 8290, 8352, 61955, '', 'ne', '', 'neni', 0, 1, 'W-5109', '4', 'W-5530', '2022-05-01', '2038-12-30'),
(5737, 65, '36930', '311', '3111913V000', '1ND', 'TAČR THÉTA II Rošt', 'pospika4', '2022-06-01', '2038-12-30', '0.12', '6', 0, 2978, 2050, 0, 0, 5028, 5028, 6727, 6778, 41900, '', 'neni', '', '', 0, 1, 'W-5113', '1', 'W-5136', '0000-00-00', '0000-00-00'),
(5738, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'pospika4', '2022-06-01', '2038-12-30', '0.08', '6', 0, 1985, 1367, 0, 0, 3352, 3352, 4485, 4518, 41900, '', 'neni', '', '', 0, 1, 'W-5113', '2', 'W-5136', '0000-00-00', '0000-00-00'),
(5739, 180, '36930', '552', '5522105V000', '1ND', 'OP PIK LASSO', 'pospika4', '2022-06-01', '2038-12-30', '0.13', '6', 0, 3226, 2221, 0, 0, 5447, 5447, 7288, 7343, 41900, '', 'neni', '', '', 0, 1, 'W-5113', '3', 'W-5136', '0000-00-00', '0000-00-00'),
(5740, 187, '36930', '552', '5522107V000', '1ND', 'OP PIK DH4.ENERGY / Feramat', 'pospika4', '2022-06-01', '2038-12-30', '0.23', '6', 0, 5708, 3929, 0, 0, 9637, 9637, 12894, 12991, 41900, '', 'neni', '', '', 0, 1, 'W-5113', '4', 'W-5136', '0000-00-00', '0000-00-00'),
(5741, 231, '36930', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'pospika4', '2022-06-01', '2038-12-30', '0.14', '6', 0, 3474, 2392, 0, 0, 5866, 5866, 7849, 7907, 41900, '', 'neni', '', '', 0, 1, 'W-5113', '5', 'W-5136', '0000-00-00', '0000-00-00'),
(5742, 62, '36930', '202', '2021901V000', '1ND', 'TRIO Zlín', 'pospika4', '2022-06-01', '2038-12-30', '0.30', '6', 0, 7445, 5125, 0, 0, 12570, 12570, 16819, 16944, 41900, '', 'neni', '', '', 0, 1, 'W-5113', '6', 'W-5136', '0000-00-00', '0000-00-00'),
(5780, 91, '36940', '888', '8889701V000', '9NN', 'Režie - ostatní', 'virabohd', '2022-06-01', '2038-12-30', '0.14', '6', 0, 4900, 3220, 0, 0, 8120, 8120, 10865, 10946, 58000, '', 'ne', '', 'neni', 0, 1, 'W-5121', '1', 'W-5171', '0000-00-00', '0000-00-00'),
(5781, 43, '36940', '533', '5331701C000', '1ND', 'OP VVV - HRAWARD', 'virabohd', '2022-06-01', '2038-12-30', '0.20', '6', 0, 7000, 4600, 0, 0, 11600, 11600, 15521, 15637, 58000, '', 'ne', '', 'neni', 0, 1, 'W-5121', '2', 'W-5171', '0000-00-00', '0000-00-00'),
(5782, 243, '36940', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'virabohd', '2022-06-01', '2038-12-30', '0.16', '6', 0, 5600, 3680, 0, 0, 9280, 9280, 12417, 12509, 58000, '', 'ne', '', 'neni', 0, 1, 'W-5121', '3', 'W-5171', '0000-00-00', '0000-00-00'),
(5823, 81, '36920', '165', '1652001V000', '1ND', 'MŠMT INTER ACTION INDIE', 'reistkri', '2022-06-01', '2038-12-30', '0.10', '6', 0, 2481, 1709, 0, 0, 4190, 4190, 5606, 5648, 41900, '', 'ne', '', 'neni', 0, 1, 'W-5125', '1', 'W-5169', '0000-00-00', '0000-00-00'),
(5824, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'reistkri', '2022-06-01', '2038-12-30', '0.55', '6', 0, 13646, 9400, 0, 0, 23045, 23045, 30834, 31065, 41900, '', 'ne', '', 'neni', 0, 1, 'W-5125', '2', 'W-5169', '0000-00-00', '0000-00-00'),
(5825, 157, '36920', '661', '6612001V000', '1ND', 'EUKI - Energy Efficiency Network', 'reistkri', '2022-06-01', '2038-12-30', '0.10', '6', 0, 2481, 1709, 0, 0, 4190, 4190, 5606, 5648, 41900, '', 'ne', '', 'neni', 0, 1, 'W-5125', '3', 'W-5169', '0000-00-00', '0000-00-00'),
(5826, 128, '36920', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'reistkri', '2022-06-01', '2038-12-30', '0.25', '6', 0, 6203, 4273, 0, 0, 10475, 10475, 14016, 14120, 41900, '', 'ne', '', 'neni', 0, 1, 'W-5125', '4', 'W-5169', '0000-00-00', '0000-00-00'),
(5834, 177, '36920', '552', '5522108V000', '1ND', 'OP PIK ALTEKO Zmrhal', 'mrkvikat', '2022-06-01', '2022-06-30', '0.15', '5', 0, 3750, 3825, 0, 300, 7875, 7575, 10537, 10616, 50500, '', 'ne', '', 'neni', 0, 1, 'W-5128', '1', 'W-5527', '2022-06-01', '2038-12-30'),
(5835, 12, '36920', '311', '3111804V000', '1ND', 'TAČR THETA Větrací jednotka (Korado)', 'mrkvikat', '2022-06-01', '2022-06-30', '0.20', '5', 0, 5000, 5100, 0, 400, 10500, 10100, 14049, 14154, 50500, '', 'ne', '', 'neni', 0, 1, 'W-5128', '2', 'W-5527', '2022-06-01', '2038-12-30'),
(5836, 263, '36920', '604', '6042202V000', '1ND', 'CRAFT HE - Vácha', 'mrkvikat', '2022-06-01', '2022-06-30', '0.10', '5', 0, 2500, 2550, 0, 200, 5250, 5050, 7025, 7077, 50500, '', 'ne', '', 'neni', 0, 1, 'W-5128', '3', 'W-5527', '2022-06-01', '2038-12-30'),
(5837, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'mrkvikat', '2022-06-01', '2022-06-30', '0.55', '5', 0, 13750, 14025, 0, 1100, 28875, 27775, 38635, 38924, 50500, '', 'ne', '', 'neni', 0, 1, 'W-5128', '4', 'W-5527', '2022-06-01', '2038-12-30'),
(5838, 45, '36910', '313', '3131901V000', '1ND', 'NCK - CAMEB M+D', 'jararobe', '2022-06-01', '2038-12-30', '0.10', 'A3', 0, 3547, 8565, 0, 3256, 15368, 12112, 20562, 20716, 121117, '', 'ne', '', 'neni', 0, 1, 'W-5129', '1', 'W-5172', '0000-00-00', '0000-00-00'),
(5839, 91, '36910', '888', '8889701V000', '9NN', 'Režie - ostatní', 'jararobe', '2022-06-01', '2038-12-30', '0.70', 'A3', 0, 24829, 35860, 0, 10744, 71433, 60689, 95577, 96292, 86698, '', 'ne', '', 'neni', 0, 1, 'W-5129', '2', 'W-5172', '0000-00-00', '0000-00-00'),
(5840, 75, '36960', '604', '6041901V000', '1ND', 'H2020 - SPARCS', 'kuzmimic', '2022-06-01', '2022-06-30', '0.55', '6', 0, 19122, 14318, 0, 0, 33440, 33440, 44743, 45077, 60800, '', 'ne', '', 'neni', 0, 1, 'W-5130', '1', 'W-5531', '2022-06-01', '2038-12-30'),
(5841, 179, '36960', '552', '5522103V000', '1ND', 'OP PIK Energocentrum II SCADA BI', 'kuzmimic', '2022-06-01', '2022-06-30', '0.25', '6', 0, 8520, 6380, 0, 0, 14900, 14900, 19936, 20085, 59600, '', 'ne', '', 'neni', 0, 1, 'W-5130', '2', 'W-5531', '2022-06-01', '2038-12-30'),
(5842, 242, '36960', '311', '3112202B001', '1ND', 'TAČR THETA IV - Power2Heat', 'kuzmimic', '2022-06-01', '2022-06-30', '0.10', '6', 0, 3543, 2653, 0, 0, 6196, 6196, 8290, 8352, 61955, '', 'ne', '', 'neni', 0, 1, 'W-5130', '3', 'W-5531', '2022-06-01', '2038-12-30'),
(5843, 263, '36960', '604', '6042202V000', '1ND', 'CRAFT HE - Vácha', 'kuzmimic', '2022-06-01', '2022-06-30', '0.10', '6', 0, 3543, 2653, 0, 0, 6196, 6196, 8290, 8352, 61955, '', 'ne', '', 'neni', 0, 1, 'W-5130', '4', 'W-5531', '2022-06-01', '2038-12-30'),
(5844, 65, '36930', '311', '3111913V000', '1ND', 'TAČR THÉTA II Rošt', 'pospika4', '2022-06-01', '2038-12-30', '0.12', '6', 0, 2978, 2050, 0, 0, 5028, 5028, 6727, 6778, 41900, '', 'ne', '', 'neni', 0, 1, 'W-5136', '1', 'W-5170', '0000-00-00', '0000-00-00'),
(5845, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'pospika4', '2022-06-01', '2038-12-30', '0.23', '6', 0, 5708, 3929, 0, 0, 9637, 9637, 12894, 12991, 41900, '', 'ne', '', 'neni', 0, 1, 'W-5136', '2', 'W-5170', '0000-00-00', '0000-00-00'),
(5846, 180, '36930', '552', '5522105V000', '1ND', 'OP PIK LASSO', 'pospika4', '2022-06-01', '2038-12-30', '0.13', '6', 0, 3226, 2221, 0, 0, 5447, 5447, 7288, 7343, 41900, '', 'ne', '', 'B8', 46200, 1, 'W-5136', '3', 'W-5170', '0000-00-00', '0000-00-00'),
(5847, 187, '36930', '552', '5522107V000', '1ND', 'OP PIK DH4.ENERGY / Feramat', 'pospika4', '2022-06-01', '2038-12-30', '0.23', '6', 0, 5708, 3929, 0, 0, 9637, 9637, 12894, 12991, 41900, '', 'ne', '', 'B5', 51000, 1, 'W-5136', '4', 'W-5170', '0000-00-00', '0000-00-00'),
(5848, 231, '36930', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'pospika4', '2022-06-01', '2038-12-30', '0.14', '6', 0, 3474, 2392, 0, 0, 5866, 5866, 7849, 7907, 41900, '', 'ne', '', 'neni', 0, 1, 'W-5136', '5', 'W-5170', '0000-00-00', '0000-00-00'),
(5849, 255, '36930', '552', '5522201V000', '1ND', 'OP PIK IX MiniBio', 'pospika4', '2022-06-01', '2038-12-30', '0.15', '6', 0, 3723, 2563, 0, 0, 6285, 6285, 8409, 8472, 41900, '', 'ne', '', 'B5', 49060, 1, 'W-5136', '6', 'W-5170', '0000-00-00', '0000-00-00'),
(5851, 256, '36255', '552', '5522122V000', '1ND', 'OP PIK IX RoboPID', 'neslamic', '2022-07-01', '2022-12-31', '0.50', '6', 0, 12405, 8595, 0, 0, 21000, 21000, 28098, 28308, 42000, '', 'ne', '', 'neni', 0, 1, 'W-5139', '1', 'W-5219', '0000-00-00', '0000-00-00'),
(5876, 19, '36255', '312', '3121804V000', '1ND', 'TAČR THETA NextGenDistrict', 'stanknic', '2022-06-01', '2022-12-31', '0.30', '6', 0, 7444, 4856, 0, 0, 12300, 12300, 16457, 16580, 41000, '', 'neni', '', '', 0, 1, 'W-5148', '1', 'W-5149', '0000-00-00', '0000-00-00'),
(5877, 167, '36255', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'stanknic', '2022-06-01', '2022-12-31', '0.05', '6', 0, 1241, 809, 0, 0, 2050, 2050, 2743, 2763, 41000, '', 'neni', '', '', 0, 1, 'W-5148', '2', 'W-5149', '0000-00-00', '0000-00-00'),
(5878, 208, '36255', '604', '6042201V000', '1ND', 'H2020 - ARV', 'stanknic', '2022-06-01', '2022-12-31', '0.05', '6', 0, 1241, 809, 0, 0, 2050, 2050, 2743, 2763, 41000, '', 'neni', '', '', 0, 1, 'W-5148', '3', 'W-5149', '0000-00-00', '0000-00-00'),
(5879, 88, '36255', '311', '3112001V000', '1ND', 'TAČR ZETA IV - WH-CarBatt', 'stanknic', '2022-06-01', '2022-12-31', '0.15', '6', 0, 3722, 2429, 0, 0, 6150, 6150, 8229, 8290, 41000, '', 'neni', '', '', 0, 1, 'W-5148', '4', 'W-5149', '0000-00-00', '0000-00-00'),
(5880, 157, '36255', '661', '6612001V000', '1ND', 'EUKI - Energy Efficiency Network', 'stanknic', '2022-06-01', '2022-12-31', '0.20', '6', 0, 4962, 3238, 0, 0, 8200, 8200, 10972, 11054, 41000, '', 'neni', '', '', 0, 1, 'W-5148', '5', 'W-5149', '0000-00-00', '0000-00-00'),
(5881, 75, '36255', '604', '6041901V000', '1ND', 'H2020 - SPARCS', 'stanknic', '2022-06-01', '2022-12-31', '0.05', '6', 0, 1241, 809, 0, 0, 2050, 2050, 2743, 2763, 41000, '', 'neni', '', '', 0, 1, 'W-5148', '6', 'W-5149', '0000-00-00', '0000-00-00'),
(5932, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'dytrijak', '2022-06-01', '2038-12-30', '0.60', '8', 0, 39000, 23840, 0, 12460, 75300, 62840, 100751, 101504, 104733, '', 'ne', 'ne', 'neni', 0, 1, 'W-5163', '1', 'W-5165', '0000-00-00', '0000-00-00'),
(5933, 79, '36930', '591', '5911901V000', '1ND', 'Interreg RESINDUSTRY', 'dytrijak', '2022-06-01', '2038-12-30', '0.40', '8', 0, 26000, 6000, 0, 0, 32000, 32000, 42816, 43136, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5163', '2', 'W-5165', '0000-00-00', '0000-00-00'),
(5981, 128, '36910', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'lupisant', '2022-07-01', '2038-12-30', '0.19', 'A3', 0, 13843, 6544, 0, 0, 20387, 20387, 27278, 27482, 107300, '', 'ne', 'ne', 'neni', 0, 1, 'W-5173', '1', 'W-5266', '0000-00-00', '0000-00-00'),
(5982, 47, '36910', '165', '1651901V000', '1ND', 'MŠMT INTER TRANSFER Annex 72 - životní cyklus budov', 'lupisant', '2022-07-01', '2038-12-30', '0.01', 'A3', 0, 729, 344, 0, 0, 1073, 1073, 1436, 1446, 107300, '', 'ne', 'ne', 'neni', 0, 1, 'W-5173', '2', 'W-5266', '0000-00-00', '0000-00-00'),
(5983, 208, '36910', '604', '6042201V000', '1ND', 'H2020 - ARV', 'lupisant', '2022-07-01', '2038-12-30', '0.40', 'A3', 0, 29143, 13777, 0, 0, 42920, 42920, 57427, 57856, 107300, '', 'ne', 'ano', 'neni', 0, 1, 'W-5173', '3', 'W-5266', '0000-00-00', '0000-00-00'),
(5984, 91, '36910', '888', '8889701V000', '9NN', 'Režie - ostatní', 'lupisant', '2022-07-01', '2038-12-30', '0.20', 'A3', 0, 14572, 6888, 0, 0, 21460, 21460, 28713, 28928, 107300, '', 'ne', 'ne', 'neni', 0, 1, 'W-5173', '4', 'W-5266', '0000-00-00', '0000-00-00'),
(5985, 177, '36920', '552', '5522108V000', '1ND', 'OP PIK ALTEKO Zmrhal', 'mrkvikat', '2022-07-01', '2022-07-31', '0.15', '5', 0, 3750, 3825, 0, 300, 7875, 7575, 10537, 10616, 50500, '', 'ne', 'ne', 'neni', 0, 1, 'W-5166', '1', 'W-5529', '2022-07-01', '2022-08-31'),
(5986, 263, '36920', '604', '6042202V000', '1ND', 'CRAFT HE - Vácha', 'mrkvikat', '2022-07-01', '2022-07-31', '0.10', '5', 0, 2500, 2550, 0, 200, 5250, 5050, 7025, 7077, 50500, '', 'ne', 'ne', 'neni', 0, 1, 'W-5166', '3', 'W-5529', '2022-07-01', '2022-08-31'),
(5987, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'mrkvikat', '2022-07-01', '2022-07-31', '0.75', '5', 0, 18750, 19125, 0, 1500, 39375, 37875, 52684, 53078, 50500, '', 'ne', 'ne', 'neni', 0, 1, 'W-5166', '4', 'W-5529', '2022-07-01', '2022-08-31'),
(5996, 294, '36256', '552', '5522206V000', '1ND', 'UNICO Kordík OP PIK IX', 'XXXtmpXXXplachste', '2022-06-01', '2023-05-31', '0.30', '6', 0, 7500, 0, 2750, 0, 10250, 7500, 13715, 13817, 25000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5181', '1', 'W-6124', '0000-00-00', '0000-00-00'),
(6020, 182, '36211', '552', '5522111V000', '1ND', 'OP PIK ReTechSDOZero', 'pavluter', '2022-07-01', '2038-12-30', '0.25', 'A3', 0, 10000, 7500, 0, 0, 17500, 17500, 23415, 23590, 70000, '', 'ne', 'ne', 'B1', 72600, 1, 'W-5193', '1', 'W-5206', '0000-00-00', '0000-00-00'),
(6021, 81, '36211', '165', '1652001V000', '1ND', 'MŠMT INTER ACTION INDIE', 'pavluter', '2022-07-01', '2038-12-30', '0.40', 'A3', 0, 16000, 12000, 0, 0, 28000, 28000, 37464, 37744, 70000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5193', '2', 'W-5206', '0000-00-00', '0000-00-00'),
(6022, 135, '36211', '311', '3112101A132', '1ND', 'TAČR PPŽ - DECOMPOSE', 'pavluter', '2022-07-01', '2038-12-30', '0.10', 'A3', 0, 4000, 3000, 0, 0, 7000, 7000, 9366, 9436, 70000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5193', '3', 'W-5206', '0000-00-00', '0000-00-00'),
(6031, 81, '36211', '165', '1652001V000', '1ND', 'MŠMT INTER ACTION INDIE', 'repkajak', '2022-07-01', '2022-09-30', '0.45', '6', 0, 11165, 6386, 0, 0, 17550, 17550, 23482, 23657, 39000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5197', '1', 'W-5794', '2022-07-01', '2038-12-30'),
(6032, 223, '36211', '301', '3012212A124', '1ND', 'GAČR LA - TRC Slovinsko - Hájek', 'repkajak', '2022-07-01', '2022-09-30', '0.55', '6', 0, 13646, 7804, 0, 0, 21450, 21450, 28700, 28915, 39000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5197', '2', 'W-5794', '2022-07-01', '2038-12-30'),
(6043, 59, '36217', '313', '3131901V008', '1ND', 'NCK - MTS', 'vitovjan', '2022-07-01', '2022-09-30', '0.10', '6', 0, 2481, 2119, 0, 0, 4600, 4600, 6155, 6201, 46000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5201', '1', 'W-5797', '2022-07-01', '2038-12-30'),
(6044, 59, '36241', '313', '3131901V008', '1ND', 'NCK - MTS', 'vitovjan', '2022-07-01', '2022-09-30', '0.20', '6', 0, 4962, 4238, 0, 0, 9200, 9200, 12310, 12402, 46000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5201', '2', 'W-5797', '2022-07-01', '2038-12-30'),
(6045, 81, '36217', '165', '1652001V000', '1ND', 'MŠMT INTER ACTION INDIE', 'vitovjan', '2022-07-01', '2022-09-30', '0.35', '6', 0, 8684, 7416, 0, 0, 16100, 16100, 21542, 21703, 46000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5201', '3', 'W-5797', '2022-07-01', '2038-12-30'),
(6046, 2, '36217', '222', '2221901V000', '1ND', 'MVČR - BV Hejtmánek', 'vitovjan', '2022-07-01', '2022-09-30', '0.10', '6', 0, 2481, 2119, 0, 0, 4600, 4600, 6155, 6201, 46000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5201', '4', 'W-5797', '2022-07-01', '2038-12-30'),
(6047, 199, '36217', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'vitovjan', '2022-07-01', '2022-09-30', '0.05', '6', 0, 1241, 1060, 0, 0, 2300, 2300, 3077, 3100, 46000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5201', '5', 'W-5797', '2022-07-01', '2038-12-30'),
(6048, 82, '36217', '301', '3012010A124', '1ND', 'GAČR - Plíseň', 'vitovjan', '2022-07-01', '2022-09-30', '0.20', '6', 0, 4962, 4238, 0, 0, 9200, 9200, 12310, 12402, 46000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5201', '6', 'W-5797', '2022-07-01', '2038-12-30'),
(6054, 150, '36214', '312', '3122102V000', '1ND', 'TAČR TREND III - Timber Guard - Inosens', 'volfmar3', '2022-07-01', '2022-09-30', '0.20', 'A3', 0, 8468, 7532, 1111, 0, 17111, 16000, 22895, 23066, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5204', '1', 'W-5801', '2022-07-01', '2038-12-30'),
(6055, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'volfmar3', '2022-07-01', '2022-09-30', '0.35', 'A3', 0, 14819, 13181, 1944, 0, 29944, 28000, 40065, 40365, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5204', '2', 'W-5801', '2022-07-01', '2038-12-30'),
(6056, 57, '36214', '313', '3131901V009', '1ND', 'NCK - BIMIP', 'volfmar3', '2022-07-01', '2022-09-30', '0.10', 'A3', 0, 4234, 3766, 556, 0, 8556, 8000, 11448, 11533, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5204', '3', 'W-5801', '2022-07-01', '2038-12-30'),
(6057, 74, '36214', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'volfmar3', '2022-07-01', '2022-09-30', '0.14', 'A3', 0, 5928, 5272, 778, 0, 11978, 11200, 16027, 16146, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5204', '4', 'W-5801', '2022-07-01', '2038-12-30'),
(6058, 47, '36216', '165', '1651901V000', '1ND', 'MŠMT INTER TRANSFER Annex 72 - životní cyklus budov', 'volfmar3', '2022-07-01', '2022-09-30', '0.01', 'A3', 0, 423, 377, 56, 0, 856, 800, 1145, 1154, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5204', '5', 'W-5801', '2022-07-01', '2038-12-30'),
(6059, 225, '36214', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'volfmar3', '2022-07-01', '2022-09-30', '0.10', 'A3', 0, 4234, 3766, 555, 0, 8555, 8000, 11447, 11532, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5204', '6', 'W-5801', '2022-07-01', '2038-12-30'),
(6063, 150, '36213', '312', '3122102V000', '1ND', 'TAČR TREND III - Timber Guard - Inosens', 'hejtmpet', '2022-07-01', '2022-09-30', '0.30', 'A3', 0, 9300, 9300, 0, 0, 18600, 18600, 24887, 25073, 62000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5187', '1', 'W-5793', '2022-07-01', '2038-12-30'),
(6064, 2, '36213', '222', '2221901V000', '1ND', 'MVČR - BV Hejtmánek', 'hejtmpet', '2022-07-01', '2022-09-30', '0.30', 'A3', 0, 9300, 9300, 0, 0, 18600, 18600, 24887, 25073, 62000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5187', '2', 'W-5793', '2022-07-01', '2038-12-30'),
(6138, 178, '36221', '552', '5522104V000', '1ND', 'OP PIK EMET', 'sourebor', '2022-07-01', '2038-12-30', '1.00', '7', 0, 27650, 40350, 0, 0, 68000, 68000, 90984, 91664, 68000, '', 'ne', 'ne', 'B5', 68000, 1, 'W-5240', '1', 'W-5264', '0000-00-00', '0000-00-00'),
(6159, 86, '36870', '888', '8888100V000', '9NN', 'Režie - správa budovy', 'smrcklu2', '2022-07-01', '2022-12-31', '0.50', '1', 0, 8650, 1750, 0, 500, 10900, 10400, 14584, 14693, 20800, '', 'ne', 'ne', 'neni', 0, 1, 'W-5250', '1', 'W-5282', '0000-00-00', '0000-00-00'),
(6185, 212, '36930', '552', '5522119V000', '1ND', 'OP PIK Solarbus', 'spickma2', '2022-07-01', '2022-07-31', '0.57', '4', 0, 12261, 10026, 0, 0, 22287, 22287, 29820, 30043, 39100, '', 'ne', 'ne', 'B4', 50761, 1, 'W-5258', '1', 'W-5382', '2022-07-01', '2022-12-31'),
(6186, 182, '36930', '552', '5522111V000', '1ND', 'OP PIK ReTechSDOZero', 'spickma2', '2022-07-01', '2022-07-31', '0.43', '4', 0, 9250, 7563, 0, 0, 16813, 16813, 22496, 22664, 39100, '', 'ne', 'ne', 'B5', 42350, 1, 'W-5258', '2', 'W-5382', '2022-07-01', '2022-12-31'),
(6197, 178, '36221', '552', '5522104V000', '1ND', 'OP PIK EMET', 'sourebor', '2022-07-01', '2038-12-30', '1.00', '7', 0, 40000, 28000, 0, 0, 68000, 68000, 90984, 91664, 68000, '', 'ne', 'ne', 'B5', 68000, 1, 'W-5264', '1', 'W-5375', '0000-00-00', '0000-00-00'),
(6232, 75, '36960', '604', '6041901V000', '1ND', 'H2020 - SPARCS', 'kuzmimic', '2022-07-01', '2022-09-30', '0.55', '6', 0, 19122, 16152, 0, 0, 35274, 35274, 47197, 47549, 64134, '', 'ne', 'ne', 'neni', 0, 1, 'W-5273', '1', 'W-5532', '2022-07-01', '2038-12-30'),
(6233, 179, '36960', '552', '5522103V000', '1ND', 'OP PIK Energocentrum II SCADA BI', 'kuzmimic', '2022-07-01', '2022-09-30', '0.25', '6', 0, 8520, 6380, 0, 0, 14900, 14900, 19936, 20085, 59600, '', 'ne', 'ne', 'B4', 59600, 1, 'W-5273', '2', 'W-5532', '2022-07-01', '2038-12-30'),
(6234, 242, '36960', '311', '3112202B001', '1ND', 'TAČR THETA IV - Power2Heat', 'kuzmimic', '2022-07-01', '2022-09-30', '0.10', '6', 0, 3667, 2746, 0, 0, 6413, 6413, 8581, 8645, 64133, '', 'ne', 'ne', 'neni', 0, 1, 'W-5273', '3', 'W-5532', '2022-07-01', '2038-12-30'),
(6235, 263, '36960', '604', '6042202V000', '1ND', 'CRAFT HE - Vácha', 'kuzmimic', '2022-07-01', '2022-09-30', '0.10', '6', 0, 3667, 2746, 0, 0, 6413, 6413, 8581, 8645, 64133, '', 'ne', 'ne', 'neni', 0, 1, 'W-5273', '4', 'W-5532', '2022-07-01', '2038-12-30'),
(6249, 198, '', '552', '5522116V000', '1ND', 'OP PIK ZdrOk / VEKRA', 'haberjos', '2022-07-01', '2038-12-30', '0.75', '6', 0, 18608, 9143, 0, 0, 27750, 27750, 37130, 37407, 37000, '', 'ne', 'ne', 'B4', 41400, 1, 'W-5226', '1', 'W-5349', '0000-00-00', '0000-00-00'),
(6267, 158, '36244', '552', '5522003V000', '1ND', 'OP PIK Amcon', 'svandon1', '2022-07-01', '2022-12-31', '0.53', '5', 0, 31980, 0, 0, 0, 31980, 31980, 42789, 43109, 60000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5284', '1', 'W-5290', '0000-00-00', '0000-00-00'),
(6279, 65, '36222', '311', '3111913V000', '1ND', 'TAČR THÉTA II Rošt', 'spaleja1', '2022-07-01', '2038-12-30', '0.10', '6', 0, 3000, 2000, 0, 0, 5000, 5000, 6690, 6740, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5287', '1', 'W-5293', '0000-00-00', '0000-00-00'),
(6280, 79, '36222', '591', '5911901V000', '1ND', 'Interreg RESINDUSTRY', 'spaleja1', '2022-07-01', '2038-12-30', '0.20', '6', 0, 6000, 4000, 0, 0, 10000, 10000, 13380, 13480, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5287', '2', 'W-5293', '0000-00-00', '0000-00-00'),
(6281, 231, '36222', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'spaleja1', '2022-07-01', '2038-12-30', '0.10', '6', 0, 3000, 2000, 0, 0, 5000, 5000, 6690, 6740, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5287', '3', 'W-5293', '0000-00-00', '0000-00-00'),
(6282, 157, '36222', '661', '6612001V000', '1ND', 'EUKI - Energy Efficiency Network', 'spaleja1', '2022-07-01', '2038-12-30', '0.15', '6', 0, 4500, 3000, 0, 0, 7500, 7500, 10035, 10110, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5287', '4', 'W-5293', '0000-00-00', '0000-00-00'),
(6283, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'spaleja1', '2022-07-01', '2038-12-30', '0.15', '6', 0, 4500, 3000, 0, 0, 7500, 7500, 10035, 10110, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5287', '5', 'W-5293', '0000-00-00', '0000-00-00'),
(6284, 232, '36222', '311', '3112203V000', '1ND', 'TAČR THETA IV - tribo-RVE (Šlechta)', 'spaleja1', '2022-07-01', '2038-12-30', '0.10', '6', 0, 3000, 2000, 0, 0, 5000, 5000, 6690, 6740, 50000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5287', '6', 'W-5293', '0000-00-00', '0000-00-00'),
(6318, 245, '36261', '221', '2212201V000', '1ND', 'MVČR SECTECH NANOPACH', 'vanzujan', '2022-08-01', '2022-12-31', '0.15', '7', 0, 4149, 5901, 0, 0, 10050, 10050, 13447, 13547, 67000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5297', '1', 'W-5327', '0000-00-00', '0000-00-00'),
(6319, 84, '36261', '312', '3122001V000', '1ND', 'TAČR ETA III - VVTO - Odorologie ', 'vanzujan', '2022-08-01', '2022-12-31', '0.15', '7', 0, 4149, 5901, 0, 0, 10050, 10050, 13447, 13547, 67000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5297', '2', 'W-5327', '0000-00-00', '0000-00-00'),
(6320, 268, '36261', '312', '3122204V000', '1ND', 'MetaMorph - TAČR KAPPA - InoCure', 'vanzujan', '2022-08-01', '2022-12-31', '0.70', '7', 0, 19362, 27538, 0, 0, 46900, 46900, 62752, 63221, 67000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5297', '3', 'W-5327', '0000-00-00', '0000-00-00'),
(6321, 199, '36216', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'kmonibar', '2022-09-01', '2023-12-31', '1.00', '7', 0, 27650, 17350, 0, 0, 45000, 45000, 60210, 60660, 45000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5301', '1', 'W-5323', '0000-00-00', '0000-00-00'),
(6352, 91, '36940', '888', '8889701V000', '9NN', 'Režie - ostatní', 'kuklipe1', '2022-09-01', '2022-12-31', '0.50', '6', 0, 17000, 13000, 0, 0, 30000, 30000, 40140, 40440, 60000, '', 'ano', 'ne', 'neni', 0, 1, 'W-5315', '1', 'W-5423', '0000-00-00', '0000-00-00'),
(6353, 264, '36261', '312', '3122203V000', '1ND', 'NextPhage - TAČR TREND III - InoCure', 'divinrad', '2022-08-01', '2038-12-30', '0.68', '6', 0, 16871, 27329, 0, 0, 44200, 44200, 59140, 59582, 65000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5296', '1', 'W-5320', '0000-00-00', '0000-00-00'),
(6354, 245, '36261', '221', '2212201V000', '1ND', 'MVČR SECTECH NANOPACH', 'divinrad', '2022-08-01', '2038-12-30', '0.16', '6', 0, 3970, 6430, 0, 0, 10400, 10400, 13915, 14019, 65000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5296', '2', 'W-5320', '0000-00-00', '0000-00-00'),
(6355, 84, '36261', '312', '3122001V000', '1ND', 'TAČR ETA III - VVTO - Odorologie ', 'divinrad', '2022-08-01', '2038-12-30', '0.16', '6', 0, 3970, 6430, 0, 0, 10400, 10400, 13915, 14019, 65000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5296', '3', 'W-5320', '0000-00-00', '0000-00-00'),
(6360, 263, '36216', '604', '6042202V000', '1ND', 'CRAFT HE - Vácha', 'kmonibar', '2022-09-01', '2022-09-30', '0.20', '7', 0, 5530, 3470, 0, 0, 9000, 9000, 12042, 12132, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5323', '1', 'W-5533', '2022-09-01', '2023-12-31'),
(6361, 167, '36216', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'kmonibar', '2022-09-01', '2022-09-30', '0.30', '7', 0, 8295, 5205, 0, 0, 13500, 13500, 18063, 18198, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5323', '2', 'W-5533', '2022-09-01', '2023-12-31'),
(6362, 199, '36216', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'kmonibar', '2022-09-01', '2022-09-30', '0.30', '7', 0, 8295, 5205, 0, 0, 13500, 13500, 18063, 18198, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5323', '3', 'W-5533', '2022-09-01', '2023-12-31'),
(6369, 19, '36255', '312', '3121804V000', '1ND', 'TAČR THETA NextGenDistrict', 'stanknic', '2022-08-01', '2022-12-31', '1.00', '6', 0, 24813, 16187, 0, 0, 41000, 41000, 54858, 55268, 41000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5326', '1', 'W-5344', '0000-00-00', '0000-00-00'),
(6373, 305, '36216', '661', '6612201V000', '1ND', 'Šance pro budovy ECF - Vlasatá', 'hodkojul', '2022-09-01', '2022-12-31', '0.09', '7', 0, 2489, 2462, 0, 0, 4950, 4950, 6623, 6673, 55000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5328', '4', 'W-5369', '0000-00-00', '0000-00-00'),
(6374, 270, '36255', '311', '3112207V000', '1ND', 'TAČR BETA - Energetické komunity - Vácha', 'vachato1', '2022-08-01', '2038-12-30', '0.20', '6', 0, 4962, 4438, 6400, 0, 15800, 9400, 21140, 21298, 47000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5331', '1', 'W-5525', '0000-00-00', '0000-00-00'),
(6375, 263, '36255', '604', '6042202V000', '1ND', 'CRAFT HE - Vácha', 'vachato1', '2022-08-01', '2038-12-30', '0.15', '6', 0, 3722, 3329, 4800, 0, 11850, 7050, 15855, 15974, 47000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5331', '2', 'W-5525', '0000-00-00', '0000-00-00'),
(6376, 242, '36255', '311', '3112202B001', '1ND', 'TAČR THETA IV - Power2Heat', 'vachato1', '2022-08-01', '2038-12-30', '0.20', '6', 0, 4962, 4438, 6400, 0, 15800, 9400, 21140, 21298, 47000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5331', '3', 'W-5525', '0000-00-00', '0000-00-00'),
(6377, 65, '36222', '311', '3111913V000', '1ND', 'TAČR THÉTA II Rošt', 'mascujak', '2022-08-01', '2038-12-30', '0.00', 'A3', 0, 0, 0, 0, 1248, 1248, 0, 1670, 1682, 64960, '', 'ne', 'ne', 'neni', 0, 1, 'W-5333', '1', 'W-5343', '0000-00-00', '0000-00-00'),
(6378, 90, '36222', '312', '3122002V000', '1ND', 'TAČR THETA III Data4energy', 'mascujak', '2022-08-01', '2038-12-30', '0.18', 'A3', 0, 5580, 6113, 0, 312, 12005, 11693, 16063, 16183, 64960, '', 'ne', 'ne', 'neni', 0, 1, 'W-5333', '2', 'W-5343', '0000-00-00', '0000-00-00'),
(6379, 93, '36222', '552', '5522002V000', '1ND', 'OP PIK Kotel GTP', 'mascujak', '2022-08-01', '2038-12-30', '0.12', 'A3', 0, 3720, 4075, 0, 751, 8546, 7795, 11435, 11520, 64960, '', 'ne', 'ne', 'neni', 0, 1, 'W-5333', '3', 'W-5343', '0000-00-00', '0000-00-00'),
(6380, 157, '36222', '661', '6612001V000', '1ND', 'EUKI - Energy Efficiency Network', 'mascujak', '2022-08-01', '2038-12-30', '0.20', 'A3', 0, 6200, 6792, 0, 1248, 14240, 12992, 19053, 19196, 64960, '', 'ne', 'ne', 'neni', 0, 1, 'W-5333', '4', 'W-5343', '0000-00-00', '0000-00-00'),
(6381, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'mascujak', '2022-08-01', '2038-12-30', '0.20', 'A3', 0, 6200, 6792, 0, 1003, 13995, 12992, 18725, 18865, 64960, '', 'ne', 'ne', 'neni', 0, 1, 'W-5333', '5', 'W-5343', '0000-00-00', '0000-00-00'),
(6382, 231, '36222', '312', '3122201V000', '', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'mascujak', '2022-08-01', '2038-12-30', '0.10', 'A3', 0, 3100, 3396, 0, 438, 6934, 6496, 9278, 9347, 64960, '', 'ne', 'ne', 'neni', 0, 1, 'W-5333', '6', 'W-5343', '0000-00-00', '0000-00-00'),
(6414, 248, '36254', '552', '5522202V000', '1ND', 'OP PIK IX KARBOX II', 'zelenva2', '2022-08-01', '2038-12-30', '1.00', '6', 0, 26189, 15811, 2000, 0, 44000, 42000, 58872, 59312, 42000, '', 'ne', 'ne', 'B10', 60500, 1, 'W-5340', '1', 'W-5380', '0000-00-00', '0000-00-00'),
(6437, 70, '36251', '313', '3131901V012', '1ND', 'NCK - CONAI', 'wawerrob', '2022-08-01', '2038-12-30', '0.10', '7', 0, 5500, 2500, 2100, 500, 10600, 8000, 14183, 14289, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5345', '1', 'W-5357', '0000-00-00', '0000-00-00'),
(6438, 243, '36251', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'wawerrob', '2022-08-01', '2038-12-30', '0.20', '7', 0, 11000, 5000, 4200, 1000, 21200, 16000, 28366, 28578, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5345', '2', 'W-5357', '0000-00-00', '0000-00-00'),
(6439, 208, '36251', '604', '6042201V000', '1ND', 'H2020 - ARV', 'wawerrob', '2022-08-01', '2038-12-30', '0.15', '7', 0, 8250, 3750, 3150, 750, 15900, 12000, 21274, 21433, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5345', '3', 'W-5357', '0000-00-00', '0000-00-00'),
(6440, 145, '36251', '312', '3122103V000', '1ND', 'TAČR DOPRAVA - SOMKo', 'wawerrob', '2022-08-01', '2038-12-30', '0.15', '7', 0, 8250, 3750, 3150, 750, 15900, 12000, 21274, 21433, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5345', '4', 'W-5357', '0000-00-00', '0000-00-00'),
(6441, 150, '36251', '312', '3122102V000', '1ND', 'TAČR TREND III - Timber Guard - Inosens', 'wawerrob', '2022-08-01', '2038-12-30', '0.20', '7', 0, 11000, 5000, 4200, 1000, 21200, 16000, 28366, 28578, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5345', '5', 'W-5357', '0000-00-00', '0000-00-00'),
(6442, 19, '36251', '312', '3121804V000', '1ND', 'TAČR THETA NextGenDistrict', 'wawerrob', '2022-08-01', '2038-12-30', '0.20', '7', 0, 11000, 5000, 4200, 1000, 21200, 16000, 28366, 28578, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5345', '6', 'W-5357', '0000-00-00', '0000-00-00'),
(6454, 91, '36910', '888', '8889701V000', '9NN', 'Režie - ostatní', 'seibejan', '2022-09-01', '2022-09-30', '1.00', '6', 0, 35000, 30000, 0, 0, 65000, 65000, 86970, 87620, 65000, '', 'ano', 'ne', 'neni', 0, 1, 'W-5077', '1', 'W-5471', '2022-09-01', '2023-12-31'),
(6473, 70, '36251', '313', '3131901V012', '1ND', 'NCK - CONAI', 'wawerrob', '2022-08-01', '2038-12-30', '0.10', '7', 0, 5500, 2500, 2100, 500, 10600, 8000, 14183, 14289, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5357', '1', 'W-5363', '0000-00-00', '0000-00-00'),
(6474, 243, '36251', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'wawerrob', '2022-08-01', '2038-12-30', '0.20', '7', 0, 11000, 5000, 4200, 1000, 21200, 16000, 28366, 28578, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5357', '2', 'W-5363', '0000-00-00', '0000-00-00'),
(6475, 208, '36251', '604', '6042201V000', '1ND', 'H2020 - ARV', 'wawerrob', '2022-08-01', '2038-12-30', '0.15', '7', 0, 8250, 3750, 3150, 750, 15900, 12000, 21274, 21433, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5357', '3', 'W-5363', '0000-00-00', '0000-00-00'),
(6476, 145, '36251', '312', '3122103V000', '1ND', 'TAČR DOPRAVA - SOMKo', 'wawerrob', '2022-08-01', '2038-12-30', '0.10', '7', 0, 5500, 2500, 3150, 500, 11650, 8000, 15588, 15704, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5357', '4', 'W-5363', '0000-00-00', '0000-00-00'),
(6477, 150, '36251', '312', '3122102V000', '1ND', 'TAČR TREND III - Timber Guard - Inosens', 'wawerrob', '2022-08-01', '2038-12-30', '0.10', '7', 0, 5500, 2500, 4200, 500, 12700, 8000, 16993, 17120, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5357', '5', 'W-5363', '0000-00-00', '0000-00-00'),
(6478, 19, '36251', '312', '3121804V000', '1ND', 'TAČR THETA NextGenDistrict', 'wawerrob', '2022-08-01', '2038-12-30', '0.35', '7', 0, 19250, 8750, 4200, 1750, 33950, 28000, 45425, 45765, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5357', '6', 'W-5363', '0000-00-00', '0000-00-00'),
(6513, 182, '36216', '552', '5522111V000', '1ND', 'OP PIK ReTechSDOZero', 'pestaja2', '2022-09-01', '2038-12-30', '0.29', '6', 0, 8468, 3132, 0, 0, 11600, 11600, 15521, 15637, 40000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5368', '1', 'W-5374', '0000-00-00', '0000-00-00'),
(6514, 81, '36216', '165', '1652001V000', '1ND', 'MŠMT INTER ACTION INDIE', 'pestaja2', '2022-09-01', '2038-12-30', '0.25', '6', 0, 7300, 2700, 0, 0, 10000, 10000, 13380, 13480, 40000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5368', '2', 'W-5374', '0000-00-00', '0000-00-00'),
(6515, 47, '36216', '165', '1651901V000', '1ND', 'MŠMT INTER TRANSFER Annex 72 - životní cyklus budov', 'pestaja2', '2022-09-01', '2038-12-30', '0.01', '6', 0, 292, 158, 0, 0, 450, 450, 602, 607, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5368', '3', 'W-5374', '0000-00-00', '0000-00-00'),
(6516, 199, '36216', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'pestaja2', '2022-09-01', '2038-12-30', '0.25', '6', 0, 7300, 3950, 0, 0, 11250, 11250, 15053, 15165, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5368', '4', 'W-5374', '0000-00-00', '0000-00-00'),
(6517, 225, '36216', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'pestaja2', '2022-09-01', '2038-12-30', '0.20', '6', 0, 5840, 3160, 0, 0, 9000, 9000, 12042, 12132, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5368', '5', 'W-5374', '0000-00-00', '0000-00-00'),
(6518, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'hodkojul', '2022-09-01', '2022-12-31', '0.20', '7', 0, 5530, 5470, 0, 0, 11000, 11000, 14718, 14828, 55000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5369', '1', 'W-5370', '0000-00-00', '0000-00-00'),
(6519, 74, '36216', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'hodkojul', '2022-09-01', '2022-12-31', '0.50', '7', 0, 13825, 13675, 0, 0, 27500, 27500, 36795, 37070, 55000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5369', '2', 'W-5370', '0000-00-00', '0000-00-00'),
(6520, 47, '36216', '165', '1651901V000', '1ND', 'MŠMT INTER TRANSFER Annex 72 - životní cyklus budov', 'hodkojul', '2022-09-01', '2022-12-31', '0.01', '7', 0, 277, 273, 0, 0, 550, 550, 736, 741, 55000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5369', '3', 'W-5370', '0000-00-00', '0000-00-00'),
(6521, 305, '36216', '661', '6612201V000', '1ND', 'Šance pro budovy ECF - Vlasatá', 'hodkojul', '2022-09-01', '2022-12-31', '0.09', '7', 0, 2489, 2462, 0, 0, 4950, 4950, 6623, 6673, 55000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5369', '4', 'W-5370', '0000-00-00', '0000-00-00'),
(6522, 199, '36216', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'hodkojul', '2022-09-01', '2022-12-31', '0.20', '7', 0, 5530, 5470, 0, 0, 11000, 11000, 14718, 14828, 55000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5369', '5', 'W-5370', '0000-00-00', '0000-00-00'),
(6535, 182, '36216', '552', '5522111V000', '1ND', 'OP PIK ReTechSDOZero', 'pestaja2', '2022-09-01', '2038-12-30', '0.29', '6', 0, 8468, 3132, 0, 0, 11600, 11600, 15521, 15637, 40000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5374', '1', 'W-5416', '0000-00-00', '0000-00-00'),
(6536, 81, '36216', '165', '1652001V000', '1ND', 'MŠMT INTER ACTION INDIE', 'pestaja2', '2022-09-01', '2038-12-30', '0.25', '6', 0, 7300, 2700, 0, 0, 10000, 10000, 13380, 13480, 40000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5374', '2', 'W-5416', '0000-00-00', '0000-00-00'),
(6537, 47, '36216', '165', '1651901V000', '1ND', 'MŠMT INTER TRANSFER Annex 72 - životní cyklus budov', 'pestaja2', '2022-09-01', '2038-12-30', '0.01', '6', 0, 292, 158, 0, 0, 450, 450, 602, 607, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5374', '3', 'W-5416', '0000-00-00', '0000-00-00'),
(6538, 275, '36216', '312', '3122105A132', '1ND', 'TAČR TREND - REWAGYPS (Staněk)', 'pestaja2', '2022-09-01', '2038-12-30', '0.25', '6', 0, 7300, 3950, 0, 0, 11250, 11250, 15053, 15165, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5374', '4', 'W-5416', '0000-00-00', '0000-00-00'),
(6539, 225, '36216', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'pestaja2', '2022-09-01', '2038-12-30', '0.20', '6', 0, 5840, 3160, 0, 0, 9000, 9000, 12042, 12132, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5374', '5', 'W-5416', '0000-00-00', '0000-00-00'),
(6577, 157, '36222', '661', '6612001V000', '1ND', 'EUKI - Energy Efficiency Network', 'suchndan', '2022-10-01', '2038-12-30', '0.20', '6', 0, 4962, 4678, 0, 0, 9640, 9640, 12898, 12995, 48200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5390', '2', 'W-5505', '0000-00-00', '0000-00-00'),
(6578, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'suchndan', '2022-10-01', '2038-12-30', '0.05', '6', 0, 1241, 1170, 0, 0, 2410, 2410, 3225, 3249, 48200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5390', '3', 'W-5505', '0000-00-00', '0000-00-00'),
(6579, 232, '36222', '311', '3112203V000', '1ND', 'TAČR THETA IV - tribo-RVE (Šlechta)', 'suchndan', '2022-10-01', '2038-12-30', '0.05', '6', 0, 1241, 1170, 0, 0, 2410, 2410, 3225, 3249, 48200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5390', '4', 'W-5505', '0000-00-00', '0000-00-00'),
(6580, 231, '36222', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'suchndan', '2022-10-01', '2038-12-30', '0.05', '6', 0, 1241, 1170, 0, 0, 2410, 2410, 3225, 3249, 48200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5390', '5', 'W-5505', '0000-00-00', '0000-00-00'),
(6581, 255, '36222', '552', '5522201V000', '1ND', 'OP PIK IX MiniBio', 'suchndan', '2022-10-01', '2038-12-30', '0.65', '6', 0, 16127, 15204, 0, 0, 31330, 31330, 41920, 42233, 48200, '', 'ne', 'ne', 'neni', 0, 1, 'W-5390', '7', 'W-5505', '0000-00-00', '0000-00-00'),
(6587, 254, '36244', '552', '5522124V000', '1ND', 'OP PIK IX EXPECT-IT II', 'matejsi2', '2022-10-01', '2023-12-31', '0.45', '5', 0, 10508, 8393, 0, 0, 18900, 18900, 25288, 25477, 42000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5392', '1', 'W-5508', '0000-00-00', '0000-00-00'),
(6592, 70, '36251', '313', '3131901V012', '1ND', 'NCK - CONAI', 'wawerrob', '2022-09-01', '2038-12-30', '0.20', '7', 0, 11000, 5000, 4200, 1000, 21200, 16000, 28366, 28578, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5397', '1', 'W-5427', '0000-00-00', '0000-00-00'),
(6593, 243, '36251', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'wawerrob', '2022-09-01', '2038-12-30', '0.20', '7', 0, 11000, 5000, 4200, 1000, 21200, 16000, 28366, 28578, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5397', '2', 'W-5427', '0000-00-00', '0000-00-00'),
(6594, 208, '36251', '604', '6042201V000', '1ND', 'H2020 - ARV', 'wawerrob', '2022-09-01', '2038-12-30', '0.15', '7', 0, 8250, 3750, 3150, 750, 15900, 12000, 21274, 21433, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5397', '3', 'W-5427', '0000-00-00', '0000-00-00'),
(6595, 145, '36251', '312', '3122103V000', '1ND', 'TAČR DOPRAVA - SOMKo', 'wawerrob', '2022-09-01', '2038-12-30', '0.15', '7', 0, 8250, 3750, 3150, 750, 15900, 12000, 21274, 21433, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5397', '4', 'W-5427', '0000-00-00', '0000-00-00'),
(6596, 150, '36251', '312', '3122102V000', '1ND', 'TAČR TREND III - Timber Guard - Inosens', 'wawerrob', '2022-09-01', '2038-12-30', '0.30', '7', 0, 16500, 7500, 6300, 1500, 31800, 24000, 42548, 42866, 80000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5397', '5', 'W-5427', '0000-00-00', '0000-00-00'),
(6609, 268, '36261', '312', '3122204V000', '1ND', 'MetaMorph - TAČR KAPPA - InoCure', 'novotp17', '2022-09-01', '2038-12-30', '0.60', '6', 0, 14886, 4914, 0, 0, 19800, 19800, 26492, 26690, 33000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5403', '1', 'W-5424', '0000-00-00', '0000-00-00'),
(6610, 84, '36261', '312', '3122001V000', '1ND', 'TAČR ETA III - VVTO - Odorologie ', 'novotp17', '2022-09-01', '2038-12-30', '0.40', '6', 0, 9924, 3276, 0, 0, 13200, 13200, 17662, 17794, 33000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5403', '2', 'W-5424', '0000-00-00', '0000-00-00'),
(6611, 268, '36261', '312', '3122204V000', '1ND', 'MetaMorph - TAČR KAPPA - InoCure', 'vanzujan', '2022-09-01', '2022-12-31', '0.90', '7', 0, 24894, 35406, 0, 0, 60300, 60300, 80681, 81284, 67000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5404', '1', 'W-5409', '0000-00-00', '0000-00-00'),
(6612, 84, '36261', '312', '3122001V000', '1ND', 'TAČR ETA III - VVTO - Odorologie ', 'vanzujan', '2022-09-01', '2022-12-31', '0.05', '7', 0, 1383, 1967, 0, 0, 3350, 3350, 4482, 4516, 67000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5404', '2', 'W-5409', '0000-00-00', '0000-00-00'),
(6613, 245, '36261', '221', '2212201V000', '1ND', 'MVČR SECTECH NANOPACH', 'vanzujan', '2022-09-01', '2022-12-31', '0.05', '7', 0, 1383, 1967, 0, 0, 3350, 3350, 4482, 4516, 67000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5404', '3', 'W-5409', '0000-00-00', '0000-00-00'),
(6619, 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-5407', '1', 'W-5584', '0000-00-00', '0000-00-00'),
(6620, 201, '36261', '894', '8941501V906', '1NE', 'Mzdový Fond RP6', '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-5407', '2', 'W-5584', '0000-00-00', '0000-00-00'),
(6621, 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-5407', '3', 'W-5584', '0000-00-00', '0000-00-00'),
(6624, 268, '36261', '312', '3122204V000', '1ND', 'MetaMorph - TAČR KAPPA - InoCure', 'vanzujan', '2022-09-01', '2022-12-31', '0.90', '7', 0, 33300, 27000, 0, 0, 60300, 60300, 80681, 81284, 67000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5409', '1', 'W-5425', '0000-00-00', '0000-00-00'),
(6625, 84, '36261', '312', '3122001V000', '1ND', 'TAČR ETA III - VVTO - Odorologie ', 'vanzujan', '2022-09-01', '2022-12-31', '0.05', '7', 0, 1850, 1500, 0, 0, 3350, 3350, 4482, 4516, 67000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5409', '2', 'W-5425', '0000-00-00', '0000-00-00'),
(6626, 245, '36261', '221', '2212201V000', '1ND', 'MVČR SECTECH NANOPACH', 'vanzujan', '2022-09-01', '2022-12-31', '0.05', '7', 0, 1850, 1500, 0, 0, 3350, 3350, 4482, 4516, 67000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5409', '3', 'W-5425', '0000-00-00', '0000-00-00'),
(6643, 298, '36256', '552', '5522207V000', '1ND', 'METEOPRESS Kordík OP PIK IX', 'XXXtmpXXXpihrtjir', '2022-08-01', '2023-05-31', '0.80', '5', 0, 22000, 19318, 18325, 0, 59643, 41318, 79802, 80399, 51647, '', 'ne', 'ne', 'neni', 0, 1, 'W-5419', '1', 'W-5548', '0000-00-00', '0000-00-00'),
(6666, 117, '36241', '302', '3022101V000', '1ND', 'GAČR - LEFM', 'postajan', '2022-10-01', '2038-12-30', '0.20', '7', 0, 7000, 5000, 0, 0, 12000, 12000, 16056, 16176, 60000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5439', '1', 'W-5489', '0000-00-00', '0000-00-00'),
(6667, 184, '36241', '552', '5522113V000', '1ND', 'OP PIK EXCON', 'postajan', '2022-10-01', '2038-12-30', '0.10', '7', 0, 3500, 2500, 0, 1000, 7000, 6000, 9366, 9436, 60000, '', 'ne', 'ne', 'B1', 73700, 1, 'W-5439', '2', 'W-5489', '0000-00-00', '0000-00-00'),
(6668, 250, '36241', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'postajan', '2022-10-01', '2038-12-30', '0.10', '7', 0, 3500, 2500, 0, 1000, 7000, 6000, 9366, 9436, 60000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5439', '3', 'W-5489', '0000-00-00', '0000-00-00'),
(6669, 225, '36241', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'postajan', '2022-10-01', '2038-12-30', '0.60', '7', 0, 21000, 15000, 0, 3000, 39000, 36000, 52182, 52572, 60000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5439', '4', 'W-5489', '0000-00-00', '0000-00-00'),
(6696, 189, '36221', '552', '5522109V000', '1ND', 'OP PIK QUANTUM', 'bohacjin', '2022-10-01', '2038-12-30', '0.40', 'A3', 0, 11500, 7700, 0, 0, 19200, 19200, 25690, 25882, 48000, '', 'ne', 'ne', 'B6', 55000, 1, 'W-5454', '1', 'W-5472', '0000-00-00', '0000-00-00'),
(6697, 248, '36221', '552', '5522202V000', '1ND', 'OP PIK IX KARBOX II', 'bohacjin', '2022-10-01', '2038-12-30', '0.25', 'A3', 0, 7188, 4813, 0, 0, 12000, 12000, 16056, 16176, 48000, '', 'ne', 'ne', 'B7', 49500, 1, 'W-5454', '2', 'W-5472', '0000-00-00', '0000-00-00'),
(6724, 225, '36213', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'hejtmpet', '2022-10-01', '2038-12-30', '0.30', 'A3', 0, 9300, 9300, 0, 0, 18600, 18600, 24887, 25073, 62000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5465', '1', 'W-5496', '0000-00-00', '0000-00-00'),
(6725, 2, '36213', '222', '2221901V000', '1ND', 'MVČR - BV Hejtmánek', 'hejtmpet', '2022-10-01', '2038-12-30', '0.30', 'A3', 0, 9300, 9300, 0, 0, 18600, 18600, 24887, 25073, 62000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5465', '2', 'W-5496', '0000-00-00', '0000-00-00'),
(6732, 225, '36217', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'vitovjan', '2022-10-01', '2038-12-30', '0.15', '6', 0, 3722, 3179, 0, 0, 6900, 6900, 9232, 9301, 46000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5468', '1', 'W-5497', '0000-00-00', '0000-00-00'),
(6733, 59, '36241', '313', '3131901V008', '1ND', 'NCK - MTS', 'vitovjan', '2022-10-01', '2038-12-30', '0.20', '6', 0, 4962, 4238, 0, 0, 9200, 9200, 12310, 12402, 46000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5468', '2', 'W-5497', '0000-00-00', '0000-00-00'),
(6734, 81, '36217', '165', '1652001V000', '1ND', 'MŠMT INTER ACTION INDIE', 'vitovjan', '2022-10-01', '2038-12-30', '0.35', '6', 0, 8684, 7416, 0, 0, 16100, 16100, 21542, 21703, 46000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5468', '3', 'W-5497', '0000-00-00', '0000-00-00'),
(6735, 2, '36217', '222', '2221901V000', '1ND', 'MVČR - BV Hejtmánek', 'vitovjan', '2022-10-01', '2038-12-30', '0.10', '6', 0, 2481, 2119, 0, 0, 4600, 4600, 6155, 6201, 46000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5468', '4', 'W-5497', '0000-00-00', '0000-00-00'),
(6736, 82, '36217', '301', '3012010A124', '1ND', 'GAČR - Plíseň', 'vitovjan', '2022-10-01', '2038-12-30', '0.20', '6', 0, 4962, 4238, 0, 0, 9200, 9200, 12310, 12402, 46000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5468', '6', 'W-5497', '0000-00-00', '0000-00-00'),
(6742, 189, '36221', '552', '5522109V000', '1ND', 'OP PIK QUANTUM', 'bohacjin', '2022-10-01', '2038-12-30', '0.40', 'A3', 0, 12400, 6800, 0, 0, 19200, 19200, 25690, 25882, 48000, '', 'ne', 'ne', 'B6', 55000, 1, 'W-5472', '1', 'W-5482', '0000-00-00', '0000-00-00'),
(6743, 248, '36221', '552', '5522202V000', '1ND', 'OP PIK IX KARBOX II', 'bohacjin', '2022-10-01', '2038-12-30', '0.25', 'A3', 0, 7750, 4250, 0, 0, 12000, 12000, 16056, 16176, 48000, '', 'ne', 'ne', 'B7', 49500, 1, 'W-5472', '2', 'W-5482', '0000-00-00', '0000-00-00'),
(6746, 263, '36216', '606', '6062202V000', '1ND', 'CRAFT HE - Vácha', 'kmonibar', '2022-10-01', '2023-12-31', '0.20', '7', 0, 5530, 3470, 0, 0, 9000, 9000, 12042, 12132, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5467', '1', 'W-5475', '0000-00-00', '0000-00-00'),
(6747, 167, '36216', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'kmonibar', '2022-10-01', '2023-12-31', '0.30', '7', 0, 0, 0, 0, 0, 13500, 13500, 18063, 18198, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5467', '2', 'W-5475', '0000-00-00', '0000-00-00'),
(6748, 128, '36216', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'kmonibar', '2022-10-01', '2023-12-31', '0.30', '7', 0, 8295, 5205, 0, 0, 13500, 13500, 18063, 18198, 45000, '', 'ne', 'ne', 'neni', 0, 1, 'W-5467', '3', 'W-5475', '0000-00-00', '0000-00-00'),
(6749, 332, '36216', '604', '6042201A133', '1ND', 'Probono H2020 - Tencar', 'salkokat', '2022-11-01', '2038-12-30', '0.10', '6', 0, 2481, 919, 0, 0, 3400, 3400, 4549, 4583, 34000, '', 'ne', 'ne', 'neni', 0, 0, 'W-5460', '1', 'W-5485', '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
(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'),
(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');

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

--
-- 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'),
(8219, 250, '36241', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'brandrad', '2023-06-01', '2038-12-30', '0.30', '7', 0, 8295, 6705, 0, 0, 15000, 15000, 20070, 20220, 50000, '', 'ne', 'ne', '', NULL, 0, 'W-6226', '1', '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=3127;

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

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

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

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

--
-- 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=8220;
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 */;
