-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Počítač: 127.0.0.1
-- Vytvořeno: Pát 06. led 2023, 10:24
-- Verze serveru: 10.4.6-MariaDB
-- Verze PHP: 7.3.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


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

--
-- Databáze: `ekonomicke_planovani`
--

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

--
-- Struktura tabulky `cil_smluvniho_vyzkumu`
--

CREATE TABLE `cil_smluvniho_vyzkumu` (
  `rok` int(11) NOT NULL,
  `RP` int(11) NOT NULL,
  `castka` decimal(11,2) NOT NULL DEFAULT 0.00 COMMENT 'Objem (Obrat-Indikátor)',
  `castka2` decimal(11,2) NOT NULL DEFAULT 0.00 COMMENT 'Obrat smluvního výzkumu(bez licenci)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Obsahuje cílové částky obratu smluvního výzkumu pro daný rok';

--
-- Vypisuji data pro tabulku `cil_smluvniho_vyzkumu`
--

INSERT INTO `cil_smluvniho_vyzkumu` (`rok`, `RP`, `castka`, `castka2`) VALUES
(2021, 0, '0.00', '0.00'),
(2021, 1, '7500000.00', '0.00'),
(2021, 2, '5680000.00', '0.00'),
(2021, 3, '2690000.00', '0.00'),
(2021, 4, '1710000.00', '0.00'),
(2021, 5, '6510000.00', '0.00'),
(2021, 6, '910000.00', '0.00'),
(2022, 1, '7390000.00', '0.00'),
(2022, 2, '7140000.00', '0.00'),
(2022, 3, '3120000.00', '0.00'),
(2022, 4, '1920000.00', '0.00'),
(2022, 5, '6630000.00', '0.00'),
(2022, 6, '1290000.00', '0.00');

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

--
-- Struktura tabulky `granty_temp`
--

CREATE TABLE `granty_temp` (
  `id` int(11) NOT NULL,
  `RP` int(11) DEFAULT NULL COMMENT 'číslo skupiny RP, ke kterému se záznam vztahuje',
  `rok` int(11) NOT NULL DEFAULT 0 COMMENT 'rok ke kterému se záznamv ztahuje',
  `id_grantu` int(11) NOT NULL DEFAULT 0 COMMENT 'id projektu v db.Projektove_rizeni tab. ''projekt''',
  `nazev_grantu` varchar(255) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `id_etapy` int(11) NOT NULL DEFAULT 0 COMMENT 'id etapy v projektovém řízení',
  `etapa_nazev` varchar(255) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `od` date NOT NULL,
  `do` date NOT NULL,
  `rozpocet_mzdove` decimal(11,2) NOT NULL DEFAULT 0.00,
  `rozpocet_ostatni` decimal(11,2) NOT NULL DEFAULT 0.00,
  `cerpani_soucasne_mzdove` decimal(11,2) NOT NULL DEFAULT 0.00,
  `cerpani_soucasne_ostatni` decimal(11,2) NOT NULL DEFAULT 0.00,
  `cerpani_soucasne_mzdove_procent` decimal(11,2) NOT NULL DEFAULT 0.00,
  `cerpani_soucasne_ostatni_procent` decimal(11,2) NOT NULL DEFAULT 0.00,
  `cerpani_predikce_mzdove` decimal(11,2) NOT NULL DEFAULT 0.00,
  `cerpani_predikce_ostatni` decimal(11,2) NOT NULL DEFAULT 0.00,
  `cerpani_predikce_mzdove_procent` decimal(11,2) NOT NULL DEFAULT 0.00,
  `cerpani_predikce_ostatni_procent` decimal(11,2) NOT NULL DEFAULT 0.00,
  `zbyde_mzdove` decimal(11,2) NOT NULL DEFAULT 0.00,
  `zbyde_ostatni` decimal(11,2) NOT NULL DEFAULT 0.00,
  `kofinancovani_mezd` decimal(11,2) NOT NULL DEFAULT 0.00,
  `kofinancovani_ostatni` decimal(11,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Obsahuje kopie hodnot z tab.''Granty'' na hl.straně Ek.plán.';

--
-- Vypisuji data pro tabulku `granty_temp`
--

INSERT INTO `granty_temp` (`id`, `RP`, `rok`, `id_grantu`, `nazev_grantu`, `id_etapy`, `etapa_nazev`, `od`, `do`, `rozpocet_mzdove`, `rozpocet_ostatni`, `cerpani_soucasne_mzdove`, `cerpani_soucasne_ostatni`, `cerpani_soucasne_mzdove_procent`, `cerpani_soucasne_ostatni_procent`, `cerpani_predikce_mzdove`, `cerpani_predikce_ostatni`, `cerpani_predikce_mzdove_procent`, `cerpani_predikce_ostatni_procent`, `zbyde_mzdove`, `zbyde_ostatni`, `kofinancovani_mezd`, `kofinancovani_ostatni`) VALUES
(10694, 5, 2021, 150, 'EUKI - Energy Efficiency Network', 459, '2. rok (2021)', '2021-01-01', '2021-12-31', '26626.00', '0.00', '26626.00', '0.00', '100.00', '0.00', '26626.00', '0.00', '100.00', '0.00', '0.00', '0.00', '2662.60', '0.00'),
(10695, 5, 2021, 105, 'H2020 - PLURAL', 301, 'Etapa 1b (01/2021-12/2021)', '2021-01-01', '2021-12-31', '1615532.00', '400377.00', '1558490.00', '381658.31', '96.47', '95.32', '1558490.00', '212110.63', '96.47', '52.98', '57042.00', '188266.37', '0.00', '0.00'),
(10696, 5, 2021, 81, 'H2020 - SPARCS', 236, '2b Etapa (01/2021-12/2021)', '2021-01-01', '2021-12-31', '996499.00', '0.00', '996499.00', '26082.92', '100.00', '0.00', '996499.00', '14495.86', '100.00', '0.00', '0.00', '-14495.86', '0.00', '0.00'),
(10697, 5, 2021, 231, 'Kreativní voucher', 723, 'Realizace 06-09/2021', '2021-06-01', '2021-09-30', '0.00', '199650.00', '0.00', '199650.00', '0.00', '100.00', '0.00', '47931.85', '0.00', '24.01', '0.00', '151718.15', '0.00', '9011.19'),
(10698, 5, 2021, 76, 'NCK - CONAI', 522, '3. rok (2021)', '2021-01-01', '2021-12-31', '941405.00', '30830.68', '941405.00', '30830.68', '100.00', '100.00', '941405.00', '17134.48', '100.00', '55.58', '0.00', '13696.20', '0.00', '0.00'),
(10699, 5, 2021, 62, 'NCK - RESOPT', 528, '3. rok (2021)', '2021-01-01', '2021-12-31', '1072419.00', '0.00', '1022942.00', '118038.68', '95.39', '0.00', '1022942.00', '65601.24', '95.39', '0.00', '49477.00', '-65601.24', '0.00', '0.00'),
(10700, 5, 2021, 173, 'OP PIK Energocentrum II SCADA BI', 546, 'etapa 1 (01-10/2021)', '2021-01-01', '2021-10-31', '662048.00', '0.00', '662048.00', '54261.67', '100.00', '0.00', '662048.00', '25099.34', '100.00', '0.00', '0.00', '-25099.34', '100358.87', '13756.81'),
(10701, 5, 2021, 173, 'OP PIK Energocentrum II SCADA BI', 547, 'etapa 2a (11 - 12/2021)', '2021-11-01', '2021-12-31', '212323.04', '0.00', '212323.04', '0.00', '100.00', '0.00', '212323.04', '0.00', '100.00', '0.00', '0.00', '0.00', '84113.42', '4040.84'),
(10702, 5, 2021, 178, 'OP PIK EXCON', 571, 'etapa 1 (01 - 10/2021)', '2021-01-01', '2021-10-31', '192100.00', '0.00', '192100.00', '0.00', '100.00', '0.00', '192100.00', '0.00', '100.00', '0.00', '0.00', '0.00', '28815.00', '27877.77'),
(10703, 5, 2021, 178, 'OP PIK EXCON', 572, 'etapa 2a (11 - 12/2021)', '2021-11-01', '2021-12-31', '132183.48', '0.00', '132183.48', '0.00', '100.00', '0.00', '132183.48', '0.00', '100.00', '0.00', '0.00', '0.00', '24085.04', '5575.55'),
(10704, 5, 2021, 258, 'OP PIK IX EXPECT-IT II', 815, 'Etapa 1a (08 - 12/2021)', '2021-08-01', '2021-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '16008.40'),
(10705, 5, 2021, 250, 'OP PIK IX KARBOX II', 827, 'Etapa 1a (07 - 12/2021)', '2021-07-01', '2021-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(10706, 5, 2021, 260, 'OP PIK IX RoboPID', 822, 'Etapa 1a (09 - 12/2021)', '2021-09-01', '2021-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '22824.18'),
(10707, 5, 2021, 256, 'OP PIK IX Softlink II', 807, 'etapa 1a (07/2021 - 12/2021)', '2021-07-01', '2021-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '10679.72'),
(10708, 5, 2021, 174, 'OP PIK LASSO', 551, 'etapa 1 (02 - 10/2021)', '2021-02-01', '2021-10-31', '357816.00', '0.00', '357816.00', '107310.35', '100.00', '0.00', '357816.00', '46772.26', '100.00', '0.00', '0.00', '-46772.26', '65200.61', '10772.78'),
(10709, 5, 2021, 174, 'OP PIK LASSO', 552, 'etapa 2a (11 - 12/2021)', '2021-11-01', '2021-12-31', '177882.42', '0.00', '177882.42', '0.00', '100.00', '0.00', '177882.42', '0.00', '100.00', '0.00', '0.00', '0.00', '29811.94', '2393.95'),
(10710, 5, 2021, 220, 'OP PIK SANS SOUCI', 694, 'Etapa 1a (02 - 12/2021)', '2021-02-01', '2021-12-31', '1016783.54', '80474.80', '1016783.54', '80474.80', '100.00', '100.00', '1016783.54', '42948.55', '100.00', '53.37', '0.00', '37526.25', '205785.99', '55973.51'),
(10711, 5, 2021, 185, 'OP PIK Senzor viskozity', 598, 'etapa 1a (06 - 12/2021)', '2021-06-01', '2021-12-31', '397698.12', '1008.00', '397698.12', '1008.00', '100.00', '100.00', '397698.12', '426.08', '100.00', '42.27', '0.00', '581.92', '73956.60', '12257.56'),
(10712, 5, 2021, 214, 'OP PIK Solarbus', 681, 'etapa 1a (03 - 12/2021)', '2021-03-01', '2021-12-31', '0.00', '40008.00', '0.00', '40008.00', '0.00', '100.00', '0.00', '20475.32', '0.00', '51.18', '0.00', '19532.68', '0.00', '35881.37'),
(10713, 5, 2021, 215, 'OP PIK StructureGuard', 686, 'etapa 1 (02-12/2021)', '2021-02-01', '2021-12-31', '489750.00', '0.00', '489750.00', '0.00', '100.00', '0.00', '489750.00', '0.00', '100.00', '0.00', '0.00', '0.00', '73462.50', '78289.88'),
(10714, 5, 2021, 188, 'OP PIK VIVA', 612, 'etapa 1 (01 - 12/2021)', '2020-12-14', '2021-12-31', '507477.00', '0.00', '507477.00', '0.00', '100.00', '0.00', '507477.00', '0.00', '100.00', '0.00', '0.00', '0.00', '79818.44', '28492.70'),
(10715, 5, 2021, 47, 'OP VVV - CAP', 245, '2021', '2021-01-01', '2021-12-31', '1481000.00', '260000.00', '1460973.00', '310687.30', '98.65', '119.50', '1460973.00', '172667.74', '98.65', '66.41', '20027.00', '87332.26', '73048.65', '8633.39'),
(10716, 5, 2021, 49, 'OP VVV - HRAWARD', 194, '4. rok - 2021', '2021-01-01', '2021-12-31', '0.00', '0.00', '59687.00', '0.00', '0.00', '0.00', '59687.00', '0.00', '0.00', '0.00', '-59687.00', '0.00', '0.00', '0.00'),
(10717, 5, 2021, 138, 'TAČR DOPRAVA - SOMKo', 412, '1. rok (2021)', '2021-04-01', '2021-12-31', '640808.00', '180137.00', '640808.00', '180137.00', '100.00', '100.00', '640808.00', '87371.76', '100.00', '48.50', '0.00', '92765.24', '64080.80', '30624.68'),
(10718, 5, 2021, 8, 'TAČR EPSILON - Matuška -Wieden (dříve Skanska)', 431, '4. rok (do 06/2021 - poslední)', '2021-01-01', '2021-06-30', '65.00', '0.00', '468.00', '0.00', '720.00', '0.00', '468.00', '0.00', '720.00', '0.00', '-403.00', '0.00', '0.00', '0.00'),
(10719, 5, 2021, 10, 'TAČR ETA - Atraktivní obec (Prost)', 252, '4. rok (poslední - do03/2021)', '2021-01-01', '2021-03-31', '117990.00', '0.00', '117990.00', '0.00', '100.00', '0.00', '117990.00', '0.00', '100.00', '0.00', '0.00', '0.00', '11799.00', '2305.08'),
(10720, 5, 2021, 33, 'TAČR ETA - Veřejná výstavba KVAS', 101, '3. rok (prodlouženo do 09/2021) - poslední', '2021-01-01', '2021-09-30', '452378.41', '110000.00', '534859.00', '16785.13', '118.23', '15.26', '534859.00', '6969.69', '118.23', '6.34', '-82480.59', '103030.31', '90475.68', '21080.20'),
(10721, 5, 2021, 161, 'TAČR ETA V - Obce mluví o vodě', 491, '1. rok (od 05/2021)', '2021-05-01', '2021-12-31', '162000.00', '0.00', '176693.00', '0.00', '109.07', '0.00', '176693.00', '0.00', '109.07', '0.00', '-14693.00', '0.00', '32400.00', '8533.20'),
(10722, 5, 2021, 179, 'TAČR GAMA - STÍNĚNÍ - Tywoniak', 576, '1. rok (2021)', '2021-01-01', '2021-11-30', '225687.00', '0.00', '228971.00', '14166.47', '101.46', '0.00', '228971.00', '7202.65', '101.46', '0.00', '-3284.00', '-7202.65', '0.00', '0.00'),
(10723, 5, 2021, 17, 'TAČR THETA - Hydronics', 228, '4. rok (poslední - do 05/2021)', '2021-01-01', '2021-05-31', '1801888.03', '191396.62', '1815231.00', '178053.65', '100.74', '93.03', '1815231.00', '40766.91', '100.74', '21.30', '-13342.97', '150629.71', '327222.87', '7403.27'),
(10724, 5, 2021, 75, 'TAČR THÉTA II Energetická odezva budov - ELPRAMO', 182, '3. etapa (2021)', '2021-01-01', '2021-12-31', '709370.00', '72177.68', '709370.00', '72177.68', '100.00', '100.00', '709370.00', '40113.51', '100.00', '55.58', '0.00', '32064.17', '70937.00', '4011.35'),
(10725, 5, 2021, 69, 'TAČR THÉTA II FLEXDER', 221, '3. rok - 2021', '2021-01-01', '2021-06-30', '166210.85', '0.00', '162634.00', '3576.85', '97.85', '0.00', '162634.00', '982.79', '97.85', '0.00', '3576.85', '-982.79', '0.00', '0.00'),
(10726, 5, 2021, 19, 'TAČR THETA NextGenDistrict', 222, '4. rok - 2021', '2021-01-01', '2021-12-31', '470408.00', '53833.00', '523109.00', '1132.00', '111.20', '2.10', '523109.00', '629.12', '111.20', '1.17', '-52701.00', '53203.88', '47040.80', '62.91'),
(10727, 5, 2021, 12, 'TAČR THETA Větrací jednotka (Korado)', 225, '4. rok (2021)', '2021-01-01', '2021-12-31', '871498.00', '116844.99', '871498.00', '100004.29', '100.00', '85.59', '871498.00', '55578.44', '100.00', '47.57', '0.00', '61266.55', '177959.89', '48557.73'),
(10728, 5, 2021, 122, 'TAČR TREND II - FullSpectraSun (Spectrasol)', 358, '2. rok (2021)', '2021-01-01', '2021-12-31', '146258.00', '0.00', '146258.00', '28967.25', '100.00', '0.00', '146258.00', '16098.85', '100.00', '0.00', '0.00', '-16098.85', '14625.80', '5900.00'),
(10729, 5, 2021, 143, 'TAČR TREND III - Timber Guard - Inosens', 432, '1. rok (2021)', '2021-01-01', '2021-12-31', '1117561.00', '1853.00', '1117561.00', '1853.00', '100.00', '100.00', '1117561.00', '1029.82', '100.00', '55.58', '0.00', '823.18', '279390.25', '257.46'),
(10730, 5, 2021, 58, 'TAČR ZETA II - FaDeDiS', 113, '3. rok (do 05/2021) - poslední', '2021-01-01', '2021-05-31', '1405.00', '0.00', '157257.00', '3821.20', '11192.67', '0.00', '157257.00', '874.90', '11192.67', '0.00', '-155852.00', '-874.90', '0.00', '0.00'),
(10731, 5, 2021, 57, 'TAČR ZETA II - MOST FBG', 109, '3. rok (do 05/2021) - poslední', '2021-01-01', '2021-05-31', '939094.81', '86309.13', '936440.00', '33507.12', '99.72', '38.82', '936440.00', '7671.74', '99.72', '8.89', '2654.81', '78637.39', '46822.00', '8632.45'),
(10732, 5, 2021, 59, 'TAČR ZETA II - Řízení SAS (AERS 2)', 115, '3. rok (do 02/2021) - poslední', '2021-01-01', '2021-02-28', '349137.00', '10169.75', '359306.75', '0.00', '102.91', '0.00', '359306.75', '0.00', '102.91', '0.00', '-10169.75', '10169.75', '52370.55', '0.00'),
(10733, 5, 2021, 61, 'TAČR ZETA II - SC Compass', 119, '3. rok (do 04/2021) - poslední', '2021-01-01', '2021-04-30', '828213.00', '104284.10', '868982.00', '170.00', '104.92', '0.16', '868982.00', '30.88', '104.92', '0.03', '-40769.00', '104253.22', '124231.95', '24664.62'),
(10734, 5, 2021, 54, 'TAČR ZETA II - Voda ve městě', 103, '3. rok (do 04/2021)', '2021-01-01', '2021-04-30', '44928.00', '0.00', '46103.00', '0.00', '102.62', '0.00', '46103.00', '0.00', '102.62', '0.00', '-1175.00', '0.00', '6739.20', '10308.28'),
(15326, 4, 2020, 4, 'GAČR Keppert - Mozaika', 141, '3. rok (do 12/2020) - poslední', '2020-01-01', '2020-12-31', '678000.00', '190000.00', '678000.00', '190000.00', '100.00', '100.00', '678000.00', '67137.27', '100.00', '35.34', '0.00', '122862.73', '82038.00', '8123.61'),
(15327, 4, 2020, 5, 'GAČR Kuklík - Dřevní hmoty', 143, '3. rok (do 12/2020) - poslední', '2020-01-01', '2020-12-31', '1000947.00', '236454.21', '1000947.00', '236454.21', '100.00', '100.00', '1000947.00', '83552.05', '100.00', '35.34', '0.00', '152902.16', '316299.25', '26402.45'),
(15328, 4, 2020, 41, 'INTERCOST - REITERMAN', 131, '3. rok (do 09/2020) - poslední', '2020-01-01', '2020-09-29', '510527.00', '105000.00', '510527.00', '105000.00', '100.00', '100.00', '510527.00', '27644.51', '100.00', '26.33', '0.00', '77355.49', '0.00', '0.00'),
(15329, 4, 2020, 63, 'NCK - BIMIP', 148, '2. rok 2020', '2020-01-01', '2020-12-31', '120000.00', '0.00', '70000.00', '0.00', '58.33', '0.00', '70000.00', '0.00', '58.33', '0.00', '50000.00', '0.00', '0.00', '0.00'),
(15330, 4, 2020, 65, 'NCK - MTS', 147, '2. rok 2020', '2020-01-01', '2020-12-31', '3345886.00', '1429389.65', '3321650.00', '399446.81', '99.28', '27.95', '3321650.00', '141146.14', '99.28', '9.87', '24236.00', '1288243.51', '0.00', '0.00'),
(15331, 4, 2020, 77, 'NCK - STD4.0', 150, '2. etapa 2020', '2020-01-01', '2020-12-31', '372458.00', '100713.98', '372458.00', '0.00', '100.00', '0.00', '372458.00', '0.00', '100.00', '0.00', '0.00', '100713.98', '0.00', '0.00'),
(15332, 4, 2020, 14, 'TA ČR Epsilon RESBY', 189, '4. rok (do 12/2020) - poslední', '2020-01-01', '2020-12-31', '166000.00', '0.00', '180108.00', '0.00', '108.50', '0.00', '180108.00', '0.00', '108.50', '0.00', '-14108.00', '0.00', '0.00', '0.00'),
(15333, 4, 2020, 57, 'TAČR ZETA II - MOST FBG', 108, '2. rok (2020)', '2020-01-01', '2020-12-31', '139500.00', '0.00', '136865.00', '519.28', '98.11', '0.00', '136865.00', '183.49', '98.11', '0.00', '2635.00', '-183.49', '6843.25', '0.00'),
(15334, 4, 2020, 42, 'TRIO Tesárek', 166, '3. rok (do 12/2020) - poslední', '2020-01-01', '2020-12-31', '321300.00', '0.00', '322781.00', '0.00', '100.46', '0.00', '322781.00', '0.00', '100.46', '0.00', '-1481.00', '0.00', '0.00', '0.00'),
(15335, 4, 2020, 21, 'TRIO TICO', 170, '5. rok (poslední - prodloužená do 12/2020)', '2020-01-01', '2020-12-31', '45946.00', '0.00', '44736.00', '0.00', '97.37', '0.00', '44736.00', '0.00', '97.37', '0.00', '1210.00', '0.00', '0.00', '0.00'),
(15336, 4, 2020, 68, 'TRIO Zlín', 171, '2. etapa (2020)', '2020-01-01', '2020-12-31', '1228259.00', '324348.88', '1234243.25', '279851.44', '100.49', '86.28', '1234243.25', '98886.64', '100.49', '30.49', '-5984.25', '225462.24', '0.00', '0.00'),
(22590, 4, 2024, 204, 'Mzdový Fond RP4', 863, 'Mzdový fond RP4 rok 2024', '2024-01-01', '2024-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(22591, 4, 2024, 253, 'TAČR DOPRAVA - FICOS', 802, '3. rok (2024 - poslední)', '2024-01-01', '2024-12-31', '797100.00', '0.00', '0.00', '0.00', '0.00', '0.00', '56616.00', '0.00', '7.10', '0.00', '740484.00', '0.00', '0.00', '0.00'),
(22592, 4, 2024, 228, 'TAČR TREND IV -  PReRaSyD ecokit', 722, '3. rok (2024 - poslední)', '2024-01-01', '2024-12-31', '270300.00', '81600.00', '0.00', '0.00', '0.00', '0.00', '2124552.00', '0.00', '786.00', '0.00', '-1854252.00', '81600.00', '27030.00', '0.00'),
(22700, 6, 2021, 203, 'Mzdový Fond RP6', 637, 'Mzdový fond RP6', '2021-01-01', '2021-12-31', '0.00', '0.00', '1077965.00', '0.00', '0.00', '0.00', '1077965.00', '0.00', '0.00', '0.00', '-1077965.00', '0.00', '0.00', '0.00'),
(22701, 6, 2021, 273, 'NextPhage - TAČR TREND III - InoCure', 886, '1. Etapa (2021 - neúčastnili jsme se)', '2021-01-01', '2021-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(22702, 6, 2021, 91, 'TAČR ETA III - VVTO - Odorologie ', 230, '2. rok - 2021', '2021-01-01', '2021-12-31', '1110386.00', '410395.17', '1110386.00', '410395.17', '100.00', '100.00', '1110386.00', '216812.54', '100.00', '52.83', '0.00', '193582.63', '222077.20', '43362.51'),
(22900, 0, 2021, 105, 'H2020 - PLURAL', 301, 'Etapa 1b (01/2021-12/2021)', '2021-01-01', '2021-12-31', '0.00', '0.00', '57042.00', '0.00', '0.00', '0.00', '65736.00', '0.00', '0.00', '0.00', '-65736.00', '0.00', '0.00', '0.00'),
(22901, 0, 2021, 81, 'H2020 - SPARCS', 236, '2b Etapa (01/2021-12/2021)', '2021-01-01', '2021-12-31', '449805.00', '439235.21', '449805.00', '75640.83', '100.00', '17.22', '449805.00', '39961.19', '100.00', '9.10', '0.00', '399274.01', '0.00', '0.00'),
(22902, 0, 2021, 67, 'INTERREG - Finerpol', 805, 'Prodloužení 10/2021-9/2022', '2021-10-01', '2022-10-31', '937500.00', '585000.00', '936324.00', '394045.98', '99.87', '67.36', '936324.00', '86228.39', '99.87', '14.74', '1176.00', '498771.61', '140448.60', '12934.26'),
(22903, 0, 2021, 72, 'Interreg LC-districts', 287, '3b semestr', '2021-01-01', '2021-01-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(22904, 0, 2021, 72, 'Interreg LC-districts', 203, '4. semestr (02/2021 - 07/2021)', '2021-02-01', '2021-07-31', '991817.15', '78489.00', '1101997.55', '78489.00', '111.11', '100.00', '1155579.55', '21466.18', '116.51', '27.35', '-163762.41', '57022.82', '148772.57', '12972.19'),
(22905, 0, 2021, 72, 'Interreg LC-districts', 204, '5. semestr', '2021-08-01', '2022-01-31', '545032.13', '84648.25', '560820.00', '51373.98', '102.90', '60.69', '560820.00', '16373.80', '102.90', '19.34', '-15787.88', '68274.45', '81754.82', '2456.07'),
(22906, 0, 2021, 85, 'Interreg RESINDUSTRY', 289, 'S3b (pouze 01/2021) ', '2021-01-01', '2021-01-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '137990.00', '0.00', '0.00', '0.00', '-137990.00', '0.00', '0.00', '0.00'),
(22907, 0, 2021, 85, 'Interreg RESINDUSTRY', 208, 'S4 (02/2021 - 07/2021) ', '2021-02-01', '2021-07-31', '0.00', '0.00', '685122.00', '29386.00', '0.00', '0.00', '781849.00', '8036.86', '0.00', '0.00', '-781849.00', '-8036.86', '0.00', '0.00'),
(22908, 0, 2021, 85, 'Interreg RESINDUSTRY', 209, 'S5a (08/2021-01/2022)', '2021-08-01', '2021-12-31', '0.00', '0.00', '452186.00', '327887.55', '0.00', '0.00', '452186.00', '104503.60', '0.00', '0.00', '-452186.00', '-104503.60', '0.00', '0.00'),
(22909, 0, 2021, 310, 'METEOPRESS Kordík OP PIK IX', 987, 'Etapa 1a (09 - 12/2021)', '2021-09-01', '2021-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '14553.57'),
(22910, 0, 2021, 74, 'MŠMT Inter-Inform EEB-CZ', 135, '3. etapa (2021)', '2021-01-01', '2021-12-31', '2008529.00', '1237275.36', '2008529.00', '1187524.36', '100.00', '95.98', '2008529.00', '627371.36', '100.00', '50.71', '0.00', '609904.00', '0.00', '0.00'),
(22911, 0, 2021, 73, 'MŠMT Inter-Inform EERA-CZ 2', 133, '3. etapa (do 12/2021) - poslední', '2021-01-01', '2021-12-31', '135000.00', '62685.43', '125864.00', '52215.14', '93.23', '83.30', '125864.00', '27585.36', '93.23', '44.01', '9136.00', '35100.07', '0.00', '0.00'),
(22912, 0, 2021, 51, 'NCK - CAMEB M+D', 532, '3. rok (2021)', '2021-01-01', '2021-12-31', '946318.20', '28964.19', '946318.20', '28964.19', '100.00', '100.00', '946318.20', '15301.84', '100.00', '52.83', '0.00', '13662.35', '36906409.80', '596771.61'),
(22913, 0, 2021, 77, 'NCK - STD4.0', 520, '3. etapa', '2021-01-01', '2021-12-31', '40985.00', '0.00', '40985.00', '0.00', '100.00', '0.00', '40985.00', '0.00', '100.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(22914, 0, 2021, 263, 'OP PIK Alpha Analytics FIT', 840, 'etapa 1a (01 - 12/2021)', '2021-01-19', '2021-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '34608.60'),
(22915, 0, 2021, 151, 'OP PIK Amcon', 462, 'E1 b', '2021-01-01', '2021-03-31', '198699.00', '27141.80', '198699.00', '27141.80', '100.00', '100.00', '198699.00', '3504.34', '100.00', '12.91', '0.00', '23637.46', '29804.85', '5520.67'),
(22916, 0, 2021, 151, 'OP PIK Amcon', 463, 'E2 a', '2021-04-01', '2021-12-31', '564480.31', '26725.30', '564480.31', '26725.30', '100.00', '100.00', '564480.31', '12225.94', '100.00', '45.75', '0.00', '14499.36', '193436.74', '16818.94'),
(22917, 0, 2021, 282, 'OP PIK IX CEBIA AUTOTRACER FIT', 900, 'Etapa 1a (08 - 12/2021)', '2021-08-01', '2021-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '30074.86'),
(22918, 0, 2021, 289, 'OP PIK IX CEBIA DIGITALIZACE VIN FIT', 936, 'E1 a (08 - 12/2021)', '2021-08-01', '2021-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '25288.16'),
(22919, 0, 2021, 84, 'OP PIK MAWISPhoto', 248, 'Etapa 2b (01/2021 - 09/2021)', '2021-01-01', '2021-09-30', '286624.00', '0.00', '286624.00', '0.00', '100.00', '0.00', '286624.00', '0.00', '100.00', '0.00', '0.00', '0.00', '127928.27', '12117.19'),
(22920, 0, 2021, 84, 'OP PIK MAWISPhoto', 249, 'Etapa 3a (10/21-12/21)', '2021-10-01', '2021-12-31', '130201.82', '0.00', '130201.82', '0.00', '100.00', '0.00', '130201.82', '0.00', '100.00', '0.00', '0.00', '0.00', '48943.64', '4039.06'),
(22921, 0, 2021, 190, 'OP PIK MOB-Bars FSv', 616, 'etapa 1 (02 - 09/2021)', '2021-02-01', '2021-09-30', '272635.00', '64380.11', '272635.00', '64380.11', '100.00', '100.00', '272635.00', '23575.87', '100.00', '36.62', '0.00', '40804.24', '88497.27', '3536.38'),
(22922, 0, 2021, 190, 'OP PIK MOB-Bars FSv', 617, 'etapa 2a (10 - 12/2021)', '2021-10-01', '2021-12-31', '170285.46', '0.00', '170285.46', '0.00', '100.00', '0.00', '170285.46', '0.00', '100.00', '0.00', '0.00', '0.00', '63064.36', '0.00'),
(22923, 0, 2021, 261, 'OP PIK TEAS_DMS FIT', 830, 'etapa 1 (01 - 09/2021)', '2021-01-01', '2021-09-30', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(22924, 0, 2021, 261, 'OP PIK TEAS_DMS FIT', 831, 'etapa 2a (10 - 12/2021)', '2021-10-01', '2021-12-31', '505128.37', '0.00', '505128.37', '0.00', '100.00', '0.00', '505128.37', '0.00', '100.00', '0.00', '0.00', '0.00', '169324.89', '9826.23'),
(22925, 0, 2021, 262, 'OP PIK TEAS_Servis FIT', 835, 'etapa 1 (01 - 09/2021)', '2021-01-07', '2021-09-30', '149913.00', '0.00', '149913.00', '0.00', '100.00', '0.00', '149913.00', '0.00', '100.00', '0.00', '0.00', '0.00', '22486.95', '26606.67'),
(22926, 0, 2021, 262, 'OP PIK TEAS_Servis FIT', 836, 'etapa 2a (10 - 12/2021)', '2021-10-01', '2021-12-31', '1097511.41', '0.00', '1097511.41', '0.00', '100.00', '0.00', '1097511.41', '0.00', '100.00', '0.00', '0.00', '0.00', '265050.30', '8868.90'),
(22927, 0, 2021, 219, 'OP PIK VYRTYCH - FEL', 803, 'Etapa 1b (01 - 12/2021)', '2021-01-01', '2021-12-31', '1093628.06', '29171.89', '1093628.06', '29171.89', '100.00', '100.00', '1093628.06', '15411.56', '100.00', '52.83', '0.00', '13760.33', '151462.94', '0.00'),
(22928, 0, 2021, 47, 'OP VVV - CAP', 245, '2021', '2021-01-01', '2021-12-31', '308200.00', '0.00', '285082.00', '46578.36', '92.50', '0.00', '285082.00', '24607.44', '92.50', '0.00', '23118.00', '-24607.44', '14254.10', '0.00'),
(22929, 0, 2021, 49, 'OP VVV - HRAWARD', 194, '4. rok - 2021', '2021-01-01', '2021-12-31', '1236962.00', '48054.30', '1177275.00', '47882.30', '95.17', '99.64', '1177275.00', '25296.31', '95.17', '52.64', '59687.00', '22757.99', '58863.75', '1264.82'),
(22930, 0, 2021, 169, 'Režie - finanční oddělení', 512, 'Rok 2021', '2021-01-01', '2021-12-31', '0.00', '0.00', '101502.00', '84906.72', '0.00', '0.00', '101502.00', '44856.38', '0.00', '0.00', '-101502.00', '-44856.38', '0.00', '0.00'),
(22931, 0, 2021, 170, 'Režie - marketing', 515, 'Rok 2021', '2021-01-01', '2021-12-31', '0.00', '0.00', '107928.00', '44208.13', '0.00', '0.00', '107928.00', '23355.24', '0.00', '0.00', '-107928.00', '-23355.24', '0.00', '0.00'),
(22932, 0, 2021, 98, 'Režie - ostatní', 534, '2. etapa', '2021-01-01', '2021-12-31', '0.00', '0.00', '7066690.40', '11544.43', '0.00', '0.00', '7066690.40', '6098.94', '0.00', '0.00', '-7066690.40', '-6098.94', '0.00', '0.00'),
(22933, 0, 2021, 168, 'Režie - projektové oddělení', 509, 'Rok 2021', '2021-01-01', '2021-12-31', '0.00', '0.00', '0.00', '18050.76', '0.00', '0.00', '0.00', '9536.25', '0.00', '0.00', '0.00', '-9536.25', '0.00', '0.00'),
(22934, 0, 2021, 167, 'Režie - ředitel', 506, 'Rok 2021', '2021-01-01', '2021-12-31', '0.00', '0.00', '366348.00', '187208.50', '0.00', '0.00', '366348.00', '98902.60', '0.00', '0.00', '-366348.00', '-98902.60', '0.00', '0.00'),
(22935, 0, 2021, 94, 'Režie - správa budovy', 535, '2. etapa 2021', '2021-01-01', '2021-12-31', '0.00', '0.00', '4758471.00', '0.00', '0.00', '0.00', '4758471.00', '0.00', '0.00', '0.00', '-4758471.00', '0.00', '0.00', '0.00'),
(22936, 0, 2021, 55, 'TAČR ZETA II - EnviBIM', 105, '3. rok (do 02/2021) - poslední', '2021-01-01', '2021-02-28', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '18184.00', '0.00', '0.00', '0.00', '-18184.00', '0.00', '0.00', '0.00'),
(22937, 0, 2021, 306, 'UNICO Kordík OP PIK IX', 974, 'Etapa 1a (09 - 12/2021)', '2021-09-01', '2021-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '6526.74'),
(31978, 1, 2024, 288, 'Cir4ConClimate EUKI - Pavlů', 1155, '3.rok - 2024', '2024-01-01', '2024-12-31', '2118425.00', '344925.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2118425.00', '344925.00', '0.00', '24262.50'),
(31979, 1, 2024, 226, 'GAČR LA - TRC Slovinsko - Hájek', 713, '3. rok (2024)', '2024-01-01', '2024-12-31', '1690000.00', '284000.00', '0.00', '0.00', '0.00', '0.00', '2119056.00', '0.00', '125.39', '0.00', '-429056.00', '284000.00', '0.00', '0.00'),
(31980, 1, 2024, 210, 'H2020 - ARV', 664, 'etapa 2b - rok 2024', '2024-01-01', '2024-12-31', '768993.75', '0.00', '0.00', '0.00', '0.00', '0.00', '69204.00', '0.00', '9.00', '0.00', '699789.75', '0.00', '0.00', '0.00'),
(31981, 1, 2024, 81, 'H2020 - SPARCS', 239, '4b etapa (01/24-9/24) POSLEDNÍ', '2024-01-01', '2024-09-30', '45441.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '45441.00', '0.00', '0.00', '0.00'),
(31982, 1, 2024, 321, 'MERIT COFUND HE - Tywoniak', 1025, '1. rok - 2022', '2022-08-01', '2027-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(31983, 1, 2024, 121, 'TAČR TREND III - Automation4Timber', 356, '4. rok (2024 - poslední)', '2024-01-01', '2024-12-31', '2671100.00', '113000.00', '0.00', '0.00', '0.00', '0.00', '1669128.00', '0.00', '62.49', '0.00', '1001972.00', '113000.00', '279245.11', '116444.98'),
(31984, 1, 2024, 228, 'TAČR TREND IV -  PReRaSyD ecokit', 722, '3. rok (2024 - poslední)', '2024-01-01', '2024-12-31', '283500.00', '0.00', '0.00', '0.00', '0.00', '0.00', '1216452.00', '0.00', '429.08', '0.00', '-932952.00', '0.00', '28350.00', '0.00'),
(31985, 1, 2024, 333, 'Vícevrstvy GAČR - FSv Sněhota', 1065, '3.rok - 2024 (poslední ?)', '2024-01-01', '2024-12-31', '559000.00', '30000.00', '0.00', '0.00', '0.00', '0.00', '704628.00', '0.00', '126.05', '0.00', '-145628.00', '30000.00', '0.00', '0.00'),
(32455, 0, 2024, 105, 'H2020 - PLURAL', 306, 'Etapa 3b (poslední - do 09/2024)', '2024-01-01', '2024-09-30', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '42462.00', '0.00', '0.00', '0.00', '-42462.00', '0.00', '0.00', '0.00'),
(32456, 0, 2024, 81, 'H2020 - SPARCS', 239, '4b etapa (01/24-9/24) POSLEDNÍ', '2024-01-01', '2024-09-30', '409726.35', '219937.50', '0.00', '0.00', '0.00', '0.00', '350127.00', '0.00', '85.45', '0.00', '59599.35', '219937.50', '0.00', '0.00'),
(32457, 0, 2024, 279, 'NEB-STAR HE - Kuzmič', 906, '3.rok - 2024', '2024-01-01', '2024-12-31', '366650.00', '116650.00', '0.00', '0.00', '0.00', '0.00', '103740.00', '0.00', '28.29', '0.00', '262910.00', '116650.00', '0.00', '0.00'),
(32458, 3, 2024, 105, 'H2020 - PLURAL', 306, 'Etapa 3b (poslední - do 09/2024)', '2024-01-01', '2024-09-30', '39040.75', '0.00', '0.00', '0.00', '0.00', '0.00', '436680.00', '0.00', '1118.52', '0.00', '-397639.25', '0.00', '0.00', '0.00'),
(37531, 2, 2024, 210, 'H2020 - ARV', 664, 'etapa 2b - rok 2024', '2024-01-01', '2024-12-31', '682171.88', '0.00', '0.00', '0.00', '0.00', '0.00', '58236.00', '0.00', '8.54', '0.00', '623935.88', '0.00', '0.00', '0.00'),
(37532, 2, 2024, 105, 'H2020 - PLURAL', 306, 'Etapa 3b (poslední - do 09/2024)', '2024-01-01', '2024-09-30', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '181980.00', '0.00', '0.00', '0.00', '-181980.00', '0.00', '0.00', '0.00'),
(37533, 2, 2024, 81, 'H2020 - SPARCS', 239, '4b etapa (01/24-9/24) POSLEDNÍ', '2024-01-01', '2024-09-30', '176294.25', '0.00', '0.00', '0.00', '0.00', '0.00', '145584.00', '0.00', '82.58', '0.00', '30710.25', '0.00', '0.00', '0.00'),
(37534, 2, 2024, 255, 'Mzdový Fond RP2', 866, 'Mzdový fond RP2 rok 2024', '2024-01-01', '2024-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(37535, 2, 2024, 142, 'TAČR KAPPA - DEXPAND', 430, '5. rok (poslední - jen do 4/2024)', '2024-01-01', '2024-04-30', '318411.00', '66667.00', '0.00', '0.00', '0.00', '0.00', '278016.00', '0.00', '87.31', '0.00', '40395.00', '66667.00', '0.00', '0.00'),
(37536, 2, 2024, 234, 'TAČR THETA IV - BIOM_Nástřiky', 736, '3. rok (2024 - poslední)', '2024-01-01', '2024-12-31', '871900.00', '419000.00', '0.00', '0.00', '0.00', '0.00', '330804.00', '0.00', '37.94', '0.00', '541096.00', '419000.00', '81543.19', '79551.71'),
(37537, 2, 2024, 237, 'TAČR THETA IV - FlexiCoMix Regulus', 743, '3. rok (2024 - poslední)', '2024-01-01', '2024-12-31', '783300.00', '133000.00', '0.00', '0.00', '0.00', '0.00', '868656.00', '0.00', '110.90', '0.00', '-85356.00', '133000.00', '78330.00', '22907.50'),
(37538, 2, 2024, 246, 'TAČR THETA IV - Power2Heat', 776, '3. rok (2024)', '2024-01-01', '2024-12-31', '354500.00', '236000.00', '0.00', '0.00', '0.00', '0.00', '595920.00', '0.00', '168.10', '0.00', '-241420.00', '236000.00', '0.00', '0.00'),
(37573, 1, 2021, 89, 'GAČR - Plíseň', 212, '2. rok - 2021', '2021-01-01', '2021-12-31', '557094.00', '184481.15', '561826.30', '179748.85', '100.85', '97.43', '561826.30', '91765.19', '100.85', '49.74', '-4732.30', '92715.96', '0.00', '0.00'),
(37574, 1, 2021, 105, 'H2020 - PLURAL', 301, 'Etapa 1b (01/2021-12/2021)', '2021-01-01', '2021-12-31', '49712.00', '0.00', '49712.00', '0.00', '100.00', '0.00', '49712.00', '0.00', '100.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(37575, 1, 2021, 80, 'H2020 - POWERSKIN PLUS', 240, '1c (01/21-3/21)', '2021-01-01', '2021-03-31', '207257.00', '798800.81', '207257.00', '2263.50', '100.00', '0.28', '207257.00', '282.41', '100.00', '0.04', '0.00', '798518.40', '0.00', '0.00'),
(37576, 1, 2021, 80, 'H2020 - POWERSKIN PLUS', 241, '2a (4/21-12/21)', '2021-04-01', '2021-12-31', '1246625.00', '1315461.00', '1246625.00', '888628.12', '100.00', '67.55', '1246625.00', '390858.50', '100.00', '29.71', '0.00', '924602.50', '0.00', '0.00'),
(37577, 1, 2021, 81, 'H2020 - SPARCS', 236, '2b Etapa (01/2021-12/2021)', '2021-01-01', '2021-12-31', '114758.00', '0.00', '114758.00', '0.00', '100.00', '0.00', '114758.00', '0.00', '100.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(37578, 1, 2021, 72, 'Interreg LC-districts', 287, '3b semestr', '2021-01-01', '2021-01-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '14649.00', '0.00', '0.00', '0.00', '-14649.00', '0.00', '0.00', '0.00'),
(37579, 1, 2021, 72, 'Interreg LC-districts', 203, '4. semestr (02/2021 - 07/2021)', '2021-02-01', '2021-07-31', '86031.90', '0.00', '68840.00', '0.00', '80.02', '0.00', '73086.00', '0.00', '84.95', '0.00', '12945.90', '0.00', '10962.90', '2669.04'),
(37580, 1, 2021, 72, 'Interreg LC-districts', 204, '5. semestr', '2021-08-01', '2022-01-31', '16056.00', '0.00', '18372.00', '0.00', '114.42', '0.00', '18372.00', '0.00', '114.42', '0.00', '-2316.00', '0.00', '2408.40', '0.00'),
(37581, 1, 2021, 216, 'MOBILITY - Veselka', 690, 'Rok 2021', '2021-03-01', '2021-12-31', '784187.87', '0.00', '780658.90', '4988.00', '99.55', '0.00', '780658.90', '2326.21', '99.55', '0.00', '3528.97', '-2326.21', '39032.95', '0.00'),
(37582, 1, 2021, 87, 'MŠMT INTER ACTION INDIE', 199, '2. rok - 2021', '2021-01-01', '2021-12-31', '1872975.00', '519364.18', '1872975.00', '519364.18', '100.00', '100.00', '1872975.00', '265145.25', '100.00', '51.05', '0.00', '254218.93', '0.00', '0.00'),
(37583, 1, 2021, 53, 'MŠMT INTER TRANSFER Annex 72 - životní cyklus budov', 160, '3. rok (do 12/2021)', '2021-01-01', '2021-12-31', '618000.00', '265592.15', '618000.00', '208092.15', '100.00', '78.35', '618000.00', '106234.98', '100.00', '40.00', '0.00', '159357.17', '0.00', '0.00'),
(37584, 1, 2021, 2, 'MVČR - BV Hejtmánek', 197, '3. rok - 2021', '2021-01-01', '2021-12-31', '780791.40', '70175.13', '780791.40', '70175.13', '100.00', '100.00', '780791.40', '35825.73', '100.00', '51.05', '0.00', '34349.40', '0.00', '0.00'),
(37585, 1, 2021, 201, 'Mzdový Fond RP1', 635, 'Mzdový fond RP1', '2021-01-01', '2021-12-31', '0.00', '0.00', '895975.00', '0.00', '0.00', '0.00', '895975.00', '0.00', '0.00', '0.00', '-895975.00', '0.00', '0.00', '0.00'),
(37586, 1, 2021, 63, 'NCK - BIMIP', 524, '3. rok (2021)', '2021-01-01', '2021-12-31', '2248732.00', '150040.00', '2248732.00', '150040.00', '100.00', '100.00', '2248732.00', '76598.26', '100.00', '51.05', '0.00', '73441.74', '0.00', '0.00'),
(37587, 1, 2021, 65, 'NCK - MTS', 526, '3. rok (2021)', '2021-01-01', '2021-12-31', '235349.00', '259.98', '235349.00', '259.98', '100.00', '100.00', '235349.00', '132.72', '100.00', '51.05', '0.00', '127.26', '0.00', '0.00'),
(37588, 1, 2021, 62, 'NCK - RESOPT', 528, '3. rok (2021)', '2021-01-01', '2021-12-31', '18000.00', '0.00', '67477.00', '0.00', '374.87', '0.00', '67477.00', '0.00', '374.87', '0.00', '-49477.00', '0.00', '0.00', '0.00'),
(37589, 1, 2021, 64, 'NCK - REVOZIM', 530, '3. rok (2021 - poslední)', '2021-01-01', '2021-12-31', '970547.00', '72838.67', '975697.00', '67688.67', '100.53', '92.93', '975697.00', '34556.35', '100.53', '47.44', '-5150.00', '38282.32', '0.00', '0.00'),
(37590, 1, 2021, 77, 'NCK - STD4.0', 520, '3. etapa', '2021-01-01', '2021-12-31', '178763.00', '0.00', '178763.00', '16803.88', '100.00', '0.00', '178763.00', '8578.70', '100.00', '0.00', '0.00', '-8578.70', '0.00', '0.00'),
(37591, 1, 2021, 174, 'OP PIK LASSO', 551, 'etapa 1 (02 - 10/2021)', '2021-02-01', '2021-10-31', '758656.00', '133930.35', '758656.00', '26620.00', '100.00', '19.88', '758656.00', '10615.15', '100.00', '7.93', '0.00', '123315.20', '210747.21', '28224.99'),
(37592, 1, 2021, 174, 'OP PIK LASSO', 552, 'etapa 2a (11 - 12/2021)', '2021-11-01', '2021-12-31', '157608.83', '81499.40', '157608.83', '81499.40', '100.00', '100.00', '157608.83', '11955.90', '100.00', '14.67', '0.00', '69543.50', '81033.49', '7711.77'),
(37593, 1, 2021, 176, 'OP PIK ReTechSDOZero', 561, 'etapa 1 (03 - 10/2021)', '2021-03-01', '2021-10-31', '583690.00', '0.00', '583690.00', '0.00', '100.00', '0.00', '583690.00', '0.00', '100.00', '0.00', '0.00', '0.00', '105023.77', '30512.80'),
(37594, 1, 2021, 176, 'OP PIK ReTechSDOZero', 562, 'etapa 2a (11 - 12/2021)', '2021-11-01', '2021-12-31', '374965.38', '0.00', '374965.38', '0.00', '100.00', '0.00', '374965.38', '0.00', '100.00', '0.00', '0.00', '0.00', '102487.43', '7628.20'),
(37595, 1, 2021, 200, 'OP PIK ZdrOk / VEKRA', 630, 'etapa 1 (03 - 11/2021)', '2021-03-01', '2021-11-30', '268826.00', '0.00', '268826.00', '0.00', '100.00', '0.00', '268826.00', '0.00', '100.00', '0.00', '0.00', '0.00', '40323.90', '54732.74'),
(37596, 1, 2021, 200, 'OP PIK ZdrOk / VEKRA', 631, 'etapa 2a (12/2021)', '2021-12-01', '2021-12-31', '158912.00', '0.00', '158912.00', '0.00', '100.00', '0.00', '158912.00', '0.00', '100.00', '0.00', '0.00', '0.00', '23836.80', '6081.40'),
(37597, 1, 2021, 47, 'OP VVV - CAP', 245, '2021', '2021-01-01', '2021-12-31', '575000.00', '0.00', '630813.00', '5288.36', '109.71', '0.00', '630813.00', '2699.81', '109.71', '0.00', '-55813.00', '-2699.81', '28750.00', '0.00'),
(37598, 1, 2021, 16, 'TAČR EPSILON - Zeleň Tywoniak', 129, '4. rok (do 12/2021) - poslední', '2021-01-01', '2021-12-31', '607963.00', '300483.94', '802353.00', '106093.94', '131.97', '35.31', '802353.00', '54162.97', '131.97', '18.03', '-194390.00', '246320.97', '60796.30', '5416.30'),
(37599, 1, 2021, 10, 'TAČR ETA - Atraktivní obec (Prost)', 252, '4. rok (poslední - do03/2021)', '2021-01-01', '2021-03-31', '152145.00', '23456.31', '175101.31', '500.00', '115.09', '2.13', '175101.31', '62.38', '115.09', '0.27', '-22956.31', '23393.93', '15214.50', '3463.86'),
(37600, 1, 2021, 33, 'TAČR ETA - Veřejná výstavba KVAS', 101, '3. rok (prodlouženo do 09/2021) - poslední', '2021-01-01', '2021-09-30', '51000.00', '0.00', '52362.00', '8158.28', '102.67', '0.00', '52362.00', '3111.80', '102.67', '0.00', '-1362.00', '-3111.80', '10200.00', '3626.42'),
(37601, 1, 2021, 161, 'TAČR ETA V - Obce mluví o vodě', 491, '1. rok (od 05/2021)', '2021-05-01', '2021-12-31', '146700.00', '19500.00', '148509.00', '2998.00', '101.23', '15.37', '148509.00', '1233.70', '101.23', '6.33', '-1809.00', '18266.30', '29340.00', '8123.54'),
(37602, 1, 2021, 179, 'TAČR GAMA - STÍNĚNÍ - Tywoniak', 576, '1. rok (2021)', '2021-01-01', '2021-11-30', '422553.00', '172272.00', '399491.00', '173655.50', '94.54', '100.80', '399491.00', '81104.18', '94.54', '47.08', '23062.00', '91167.82', '0.00', '0.00'),
(37603, 1, 2021, 128, 'TAČR PPŽ - DECOMPOSE', 383, '1. rok (2021)', '2021-01-01', '2021-12-31', '330000.00', '24000.00', '336465.00', '17535.00', '101.96', '73.06', '336465.00', '8951.95', '101.96', '37.30', '-6465.00', '15048.05', '0.00', '0.00'),
(37604, 1, 2021, 122, 'TAČR TREND II - FullSpectraSun (Spectrasol)', 358, '2. rok (2021)', '2021-01-01', '2021-12-31', '65251.00', '0.00', '65251.00', '0.00', '100.00', '0.00', '65251.00', '0.00', '100.00', '0.00', '0.00', '0.00', '6525.10', '2212.50'),
(37605, 1, 2021, 121, 'TAČR TREND III - Automation4Timber', 353, '1. rok (2021)', '2021-01-01', '2021-12-31', '1813508.33', '117329.40', '1813508.33', '117329.40', '100.00', '100.00', '1813508.33', '59898.88', '100.00', '51.05', '0.00', '57430.52', '181350.83', '55462.39'),
(37606, 1, 2021, 55, 'TAČR ZETA II - EnviBIM', 105, '3. rok (do 02/2021) - poslední', '2021-01-01', '2021-02-28', '198919.00', '9100.61', '198932.67', '9086.94', '100.01', '99.85', '198932.67', '739.19', '100.01', '8.12', '-13.67', '8361.42', '0.00', '0.00'),
(37607, 1, 2021, 56, 'TAČR ZETA II - Karbeton II', 107, '3. rok (do 05/2021) - poslední', '2021-01-01', '2021-05-31', '691445.00', '469040.43', '700473.00', '460012.43', '101.31', '98.08', '700473.00', '96749.93', '101.31', '20.63', '-9028.00', '372290.50', '0.00', '0.00'),
(37608, 1, 2021, 61, 'TAČR ZETA II - SC Compass', 119, '3. rok (do 04/2021) - poslední', '2021-01-01', '2021-04-30', '27939.00', '0.00', '27874.80', '0.00', '99.77', '0.00', '27874.80', '0.00', '99.77', '0.00', '64.20', '0.00', '4181.22', '3047.86'),
(37609, 1, 2021, 54, 'TAČR ZETA II - Voda ve městě', 103, '3. rok (do 04/2021)', '2021-01-01', '2021-04-30', '302832.00', '442202.63', '595728.00', '148131.63', '196.72', '33.50', '595728.00', '24714.57', '196.72', '5.59', '-292896.00', '417488.06', '45424.80', '27759.83'),
(37610, 1, 2021, 104, 'TAČR ZETA IV - MOBRECLIN recyklační linka', 298, '2. rok (2021)', '2021-01-01', '2021-12-31', '136697.00', '1998.00', '136697.00', '1998.00', '100.00', '100.00', '136697.00', '1020.02', '100.00', '51.05', '0.00', '977.98', '0.00', '0.00'),
(37611, 1, 2021, 68, 'TRIO Zlín', 172, '3. etapa (2021)', '2021-01-01', '2021-12-31', '259364.00', '0.00', '259364.00', '19316.79', '100.00', '0.00', '259364.00', '9861.59', '100.00', '0.00', '0.00', '-9861.59', '0.00', '0.00'),
(41270, 4, 2021, 110, 'GAČR - LEFM', 319, '1. rok (2021)', '2021-01-01', '2021-12-31', '687757.00', '191593.53', '687757.00', '191549.07', '100.00', '99.98', '687757.00', '96973.38', '100.00', '50.61', '0.00', '94620.15', '0.00', '0.00'),
(41271, 4, 2021, 204, 'Mzdový Fond RP4', 638, 'Mzdový fond RP4', '2021-01-01', '2021-12-31', '0.00', '0.00', '10000.00', '0.00', '0.00', '0.00', '10000.00', '0.00', '0.00', '0.00', '-10000.00', '0.00', '0.00', '0.00'),
(41272, 4, 2021, 63, 'NCK - BIMIP', 524, '3. rok (2021)', '2021-01-01', '2021-12-31', '62736.00', '0.00', '62736.00', '0.00', '100.00', '0.00', '62736.00', '0.00', '100.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(41273, 4, 2021, 65, 'NCK - MTS', 526, '3. rok (2021)', '2021-01-01', '2021-12-31', '1798866.00', '240162.65', '1798866.00', '236924.65', '100.00', '98.65', '1798866.00', '119945.16', '100.00', '49.94', '0.00', '120217.49', '0.00', '0.00'),
(41274, 4, 2021, 77, 'NCK - STD4.0', 520, '3. etapa', '2021-01-01', '2021-12-31', '138464.80', '16803.88', '138464.80', '0.00', '100.00', '0.00', '138464.80', '0.00', '100.00', '0.00', '0.00', '16803.88', '0.00', '0.00'),
(41275, 4, 2021, 178, 'OP PIK EXCON', 571, 'etapa 1 (01 - 10/2021)', '2021-01-01', '2021-10-31', '49216.00', '58413.83', '49216.00', '58413.83', '100.00', '100.00', '49216.00', '24613.29', '100.00', '42.14', '0.00', '33800.54', '7382.40', '10587.54'),
(41276, 4, 2021, 178, 'OP PIK EXCON', 572, 'etapa 2a (11 - 12/2021)', '2021-11-01', '2021-12-31', '97587.44', '39424.77', '97587.44', '39424.77', '100.00', '100.00', '97587.44', '5699.97', '100.00', '14.46', '0.00', '33724.80', '33625.68', '2234.10'),
(41277, 4, 2021, 177, 'OP PIK FASHEX / Dekmetal', 566, 'etapa 1a (06 - 12/2021)', '2021-06-01', '2021-12-31', '187810.84', '0.00', '187810.84', '0.00', '100.00', '0.00', '187810.84', '0.00', '100.00', '0.00', '0.00', '0.00', '40546.79', '0.00'),
(41278, 4, 2021, 258, 'OP PIK IX EXPECT-IT II', 815, 'Etapa 1a (08 - 12/2021)', '2021-08-01', '2021-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(41279, 4, 2021, 215, 'OP PIK StructureGuard', 686, 'etapa 1 (02-12/2021)', '2021-02-01', '2021-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(41280, 4, 2021, 200, 'OP PIK ZdrOk / VEKRA', 630, 'etapa 1 (03 - 11/2021)', '2021-03-01', '2021-11-30', '68310.00', '0.00', '68310.00', '0.00', '100.00', '0.00', '68310.00', '0.00', '100.00', '0.00', '0.00', '0.00', '10246.50', '0.00'),
(41281, 4, 2021, 200, 'OP PIK ZdrOk / VEKRA', 631, 'etapa 2a (12/2021)', '2021-12-01', '2021-12-31', '43654.00', '0.00', '43654.00', '0.00', '100.00', '0.00', '43654.00', '0.00', '100.00', '0.00', '0.00', '0.00', '6548.10', '0.00'),
(41282, 4, 2021, 222, 'TAČR TREND - Svora', 703, '1. rok (2021)', '2021-03-01', '2021-12-31', '180000.00', '0.00', '180000.00', '0.00', '100.00', '0.00', '180000.00', '0.00', '100.00', '0.00', '0.00', '0.00', '18000.00', '2000.00'),
(41283, 4, 2021, 57, 'TAČR ZETA II - MOST FBG', 109, '3. rok (do 05/2021) - poslední', '2021-01-01', '2021-05-31', '70500.00', '0.00', '70768.00', '0.00', '100.38', '0.00', '70768.00', '0.00', '100.38', '0.00', '-268.00', '0.00', '3525.00', '1232.59'),
(41284, 4, 2021, 68, 'TRIO Zlín', 172, '3. etapa (2021)', '2021-01-01', '2021-12-31', '1896127.00', '536846.10', '1896127.00', '517529.31', '100.00', '96.40', '1896127.00', '262003.71', '100.00', '48.80', '0.00', '274842.39', '0.00', '0.00'),
(43056, 3, 2023, 105, 'H2020 - PLURAL', 304, 'Etapa 2b (do 09/2023)', '2023-01-01', '2023-09-30', '319441.75', '0.00', '0.00', '0.00', '0.00', '0.00', '436680.00', '0.00', '136.70', '0.00', '-117238.25', '0.00', '0.00', '0.00'),
(43057, 3, 2023, 105, 'H2020 - PLURAL', 305, 'Etapa 3a (10-12/2023)', '2023-10-01', '2023-12-31', '106480.50', '0.00', '0.00', '0.00', '0.00', '0.00', '145560.00', '0.00', '136.70', '0.00', '-39079.50', '0.00', '0.00', '0.00'),
(43058, 3, 2023, 265, 'Mzdový Fond RP3', 852, '2023', '2023-01-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(43059, 3, 2023, 172, 'OP PIK EMET', 1135, 'Etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '141158.13', '0.00', '0.00', '0.00', '0.00', '0.00', '494390.00', '0.00', '350.24', '0.00', '-353231.87', '0.00', '21173.72', '1078.93'),
(43060, 3, 2023, 173, 'OP PIK Energocentrum II SCADA BI', 550, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '771490.80', '2777.78', '0.00', '0.00', '0.00', '0.00', '793955.00', '0.00', '102.91', '0.00', '-22464.20', '2777.78', '115723.62', '16287.93'),
(43061, 3, 2023, 188, 'OP PIK VIVA', 615, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '733558.75', '93750.00', '0.00', '0.00', '0.00', '0.00', '951680.00', '0.00', '129.73', '0.00', '-218121.25', '93750.00', '110033.81', '16505.07'),
(43062, 3, 2023, 200, 'OP PIK ZdrOk / VEKRA', 634, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '903819.00', '272500.00', '0.00', '0.00', '0.00', '0.00', '1440594.00', '0.00', '159.39', '0.00', '-536775.00', '272500.00', '135572.85', '11574.27'),
(43063, 3, 2023, 122, 'TAČR TREND II - FullSpectraSun (Spectrasol)', 360, '4. rok (do 09/2023)', '2023-01-01', '2023-09-30', '381500.00', '52000.00', '0.00', '0.00', '0.00', '0.00', '377253.00', '0.00', '98.89', '0.00', '4247.00', '52000.00', '37725.30', '10758.30'),
(44416, 1, 2023, 288, 'Cir4ConClimate EUKI - Pavlů', 1154, '2.rok - 2023', '2023-01-01', '2023-12-31', '2118425.00', '358825.00', '0.00', '0.00', '0.00', '0.00', '396084.00', '0.00', '18.70', '0.00', '1722341.00', '358825.00', '39608.40', '24400.00'),
(44417, 1, 2023, 272, 'CRAFT HE - Vácha', 883, 'rok 2023', '2023-01-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '145584.00', '0.00', '0.00', '0.00', '-145584.00', '0.00', '0.00', '0.00'),
(44418, 1, 2023, 226, 'GAČR LA - TRC Slovinsko - Hájek', 712, '2. rok (2023)', '2023-01-01', '2023-12-31', '1699000.00', '248000.00', '0.00', '0.00', '0.00', '0.00', '2093172.00', '0.00', '123.20', '0.00', '-394172.00', '248000.00', '0.00', '0.00'),
(44419, 1, 2023, 210, 'H2020 - ARV', 663, 'etapa 1b - rok 2023', '2023-01-01', '2023-06-30', '768993.75', '0.00', '0.00', '0.00', '0.00', '0.00', '133332.00', '0.00', '17.34', '0.00', '635661.75', '0.00', '0.00', '0.00'),
(44420, 1, 2023, 210, 'H2020 - ARV', 1133, 'etapa 2a - rok 2023', '2023-07-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '133332.00', '0.00', '0.00', '0.00', '-133332.00', '0.00', '0.00', '0.00'),
(44421, 1, 2023, 80, 'H2020 - POWERSKIN PLUS', 244, '3b (01/23-09/23) POSLEDNÍ', '2023-01-01', '2023-09-30', '646159.75', '768750.00', '0.00', '0.00', '0.00', '0.00', '392796.00', '0.00', '60.79', '0.00', '253363.75', '768750.00', '0.00', '0.00'),
(44422, 1, 2023, 81, 'H2020 - SPARCS', 219, '3b etapa - 01/2023-09/2023', '2023-01-01', '2023-09-30', '45441.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '45441.00', '0.00', '0.00', '0.00'),
(44423, 1, 2023, 81, 'H2020 - SPARCS', 220, '4a etapa (10/2023 - 12/2023)', '2023-10-01', '2023-12-31', '15147.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '15147.00', '0.00', '0.00', '0.00'),
(44424, 1, 2023, 321, 'MERIT COFUND HE - Tywoniak', 1025, '1. rok - 2022', '2022-08-01', '2027-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44425, 1, 2023, 201, 'Mzdový Fond RP1', 849, '2023', '2023-01-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '554676.00', '0.00', '0.00', '0.00', '-554676.00', '0.00', '0.00', '0.00'),
(44426, 1, 2023, 174, 'OP PIK LASSO', 555, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '670680.00', '167500.00', '0.00', '0.00', '0.00', '0.00', '875970.00', '0.00', '130.61', '0.00', '-205290.00', '167500.00', '100602.00', '14795.97'),
(44427, 1, 2023, 176, 'OP PIK ReTechSDOZero', 565, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '847582.96', '11111.11', '0.00', '0.00', '0.00', '0.00', '810985.00', '0.00', '95.68', '0.00', '36597.96', '11111.11', '121647.75', '19070.50'),
(44428, 1, 2023, 200, 'OP PIK ZdrOk / VEKRA', 634, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '962021.00', '0.00', '0.00', '0.00', '0.00', '0.00', '991950.00', '0.00', '103.11', '0.00', '-29929.00', '0.00', '144303.15', '30407.13'),
(44429, 1, 2023, 47, 'OP VVV - CAP', 1134, '2023 (poslední po prodloužení)', '2023-01-01', '2023-04-30', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44430, 1, 2023, 161, 'TAČR ETA V - Obce mluví o vodě', 493, '3. rok (2023 - poslední)', '2023-01-01', '2023-12-31', '201750.00', '6500.00', '0.00', '0.00', '0.00', '0.00', '475824.00', '0.00', '235.85', '0.00', '-274074.00', '6500.00', '40350.00', '10344.00'),
(44431, 1, 2023, 128, 'TAČR PPŽ - DECOMPOSE', 385, '3. rok (2023 - poslední)', '2023-01-01', '2023-12-31', '330000.00', '24000.00', '0.00', '0.00', '0.00', '0.00', '347784.00', '0.00', '105.39', '0.00', '-17784.00', '24000.00', '0.00', '0.00'),
(44432, 1, 2023, 122, 'TAČR TREND II - FullSpectraSun (Spectrasol)', 360, '4. rok (do 09/2023)', '2023-01-01', '2023-09-30', '24300.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '24300.00', '0.00', '0.00', '686.70'),
(44433, 1, 2023, 121, 'TAČR TREND III - Automation4Timber', 355, '3. rok (2023)', '2023-01-01', '2023-12-31', '2541900.00', '113000.00', '0.00', '0.00', '0.00', '0.00', '2320812.00', '0.00', '91.30', '0.00', '221088.00', '113000.00', '268285.87', '76726.61'),
(44434, 1, 2023, 228, 'TAČR TREND IV -  PReRaSyD ecokit', 721, '2. rok (2023)', '2023-01-01', '2023-12-31', '623700.00', '0.00', '0.00', '0.00', '0.00', '0.00', '3139104.00', '0.00', '503.30', '0.00', '-2515404.00', '0.00', '62370.00', '0.00'),
(44435, 1, 2023, 333, 'Vícevrstvy GAČR - FSv Sněhota', 1064, '2.rok - 2023', '2023-01-01', '2023-12-31', '559000.00', '30000.00', '0.00', '513.00', '0.00', '1.71', '1019088.00', '62244.00', '182.31', '207.48', '-460088.00', '-32244.00', '0.00', '0.00'),
(44518, 2, 2023, 210, 'H2020 - ARV', 663, 'etapa 1b - rok 2023', '2023-01-01', '2023-06-30', '682171.88', '0.00', '0.00', '0.00', '0.00', '0.00', '29118.00', '0.00', '4.27', '0.00', '653053.88', '0.00', '0.00', '0.00'),
(44519, 2, 2023, 210, 'H2020 - ARV', 1133, 'etapa 2a - rok 2023', '2023-07-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '29118.00', '0.00', '0.00', '0.00', '-29118.00', '0.00', '0.00', '0.00'),
(44520, 2, 2023, 105, 'H2020 - PLURAL', 304, 'Etapa 2b (do 09/2023)', '2023-01-01', '2023-09-30', '57375.00', '0.00', '0.00', '0.00', '0.00', '0.00', '600534.00', '0.00', '1046.68', '0.00', '-543159.00', '0.00', '0.00', '0.00'),
(44521, 2, 2023, 105, 'H2020 - PLURAL', 305, 'Etapa 3a (10-12/2023)', '2023-10-01', '2023-12-31', '19125.00', '0.00', '0.00', '0.00', '0.00', '0.00', '200178.00', '0.00', '1046.68', '0.00', '-181053.00', '0.00', '0.00', '0.00'),
(44522, 2, 2023, 80, 'H2020 - POWERSKIN PLUS', 244, '3b (01/23-09/23) POSLEDNÍ', '2023-01-01', '2023-09-30', '283018.75', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '283018.75', '0.00', '0.00', '0.00'),
(44523, 2, 2023, 81, 'H2020 - SPARCS', 219, '3b etapa - 01/2023-09/2023', '2023-01-01', '2023-09-30', '155256.75', '0.00', '0.00', '0.00', '0.00', '0.00', '145584.00', '0.00', '93.77', '0.00', '9672.75', '0.00', '0.00', '0.00');
INSERT INTO `granty_temp` (`id`, `RP`, `rok`, `id_grantu`, `nazev_grantu`, `id_etapy`, `etapa_nazev`, `od`, `do`, `rozpocet_mzdove`, `rozpocet_ostatni`, `cerpani_soucasne_mzdove`, `cerpani_soucasne_ostatni`, `cerpani_soucasne_mzdove_procent`, `cerpani_soucasne_ostatni_procent`, `cerpani_predikce_mzdove`, `cerpani_predikce_ostatni`, `cerpani_predikce_mzdove_procent`, `cerpani_predikce_ostatni_procent`, `zbyde_mzdove`, `zbyde_ostatni`, `kofinancovani_mezd`, `kofinancovani_ostatni`) VALUES
(44524, 2, 2023, 81, 'H2020 - SPARCS', 220, '4a etapa (10/2023 - 12/2023)', '2023-10-01', '2023-12-31', '51752.25', '0.00', '0.00', '0.00', '0.00', '0.00', '48528.00', '0.00', '93.77', '0.00', '3224.25', '0.00', '0.00', '0.00'),
(44525, 2, 2023, 357, 'Interreg RESINDUSTRY - Lump Sum phase 2', 1137, 'Udržovací fáze', '2022-08-01', '2023-07-31', '0.00', '0.00', '0.00', '22391.00', '0.00', '0.00', '0.00', '51899.12', '0.00', '0.00', '0.00', '-51899.12', '0.00', '10126.90'),
(44526, 2, 2023, 255, 'Mzdový Fond RP2', 865, 'Mzdový fond RP2 rok 2023', '2023-01-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44527, 2, 2023, 171, 'OP PIK ALTEKO Zmrhal', 540, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-30', '534994.83', '72413.79', '0.00', '0.00', '0.00', '0.00', '1012230.00', '0.00', '189.20', '0.00', '-477235.17', '72413.79', '80249.22', '12037.35'),
(44528, 2, 2023, 181, 'OP PIK DH4.ENERGY / Feramat', 585, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '612434.12', '0.00', '0.00', '0.00', '0.00', '0.00', '239680.00', '0.00', '39.14', '0.00', '372754.12', '0.00', '35952.00', '13779.70'),
(44529, 2, 2023, 172, 'OP PIK EMET', 1135, 'Etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '451611.88', '0.00', '0.00', '0.00', '0.00', '0.00', '627320.00', '0.00', '138.91', '0.00', '-175708.12', '0.00', '67741.78', '12257.64'),
(44530, 2, 2023, 177, 'OP PIK FASHEX / Dekmetal', 570, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '552376.25', '28636.25', '0.00', '0.00', '0.00', '0.00', '294430.00', '0.00', '53.30', '0.00', '257946.25', '28636.25', '44164.50', '16197.20'),
(44531, 2, 2023, 250, 'OP PIK IX KARBOX II', 829, 'Etapa 2b (01 - 05/2023)', '2023-01-01', '2023-05-31', '1696189.71', '0.00', '0.00', '160632.34', '0.00', '0.00', '1995860.00', '6022039.50', '117.67', '0.00', '-299670.29', '-6022039.50', '254428.46', '53947.15'),
(44532, 2, 2023, 259, 'OP PIK IX MiniBio', 971, 'Etapa 2b (01 - 05/2023)', '2023-01-01', '2023-05-31', '792593.53', '0.00', '0.00', '163478.00', '0.00', '0.00', '850300.00', '6128722.10', '107.28', '0.00', '-57706.47', '-6128722.10', '0.00', '0.00'),
(44533, 2, 2023, 199, 'OP PIK Multi-Heat / TECHTRANS', 629, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '703113.42', '0.00', '0.00', '0.00', '0.00', '0.00', '418125.00', '0.00', '59.47', '0.00', '284988.42', '0.00', '62718.75', '15819.57'),
(44534, 2, 2023, 183, 'OP PIK QUANTUM', 593, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-30', '476370.00', '12500.00', '0.00', '0.00', '0.00', '0.00', '724665.00', '0.00', '152.12', '0.00', '-248295.00', '12500.00', '71455.50', '10718.33'),
(44535, 2, 2023, 142, 'TAČR KAPPA - DEXPAND', 429, '4. rok (2023)', '2023-01-01', '2023-12-31', '955234.00', '200000.00', '0.00', '0.00', '0.00', '0.00', '1140456.00', '0.00', '119.39', '0.00', '-185222.00', '200000.00', '0.00', '0.00'),
(44536, 2, 2023, 97, 'TAČR THETA III Data4energy', 267, '4. rok (do 12/2023) poslední', '2023-01-01', '2023-12-31', '433600.00', '306000.00', '0.00', '6500.00', '0.00', '2.12', '940488.00', '591500.00', '216.90', '193.30', '-506888.00', '-285500.00', '43360.00', '49090.00'),
(44537, 2, 2023, 234, 'TAČR THETA IV - BIOM_Nástřiky', 735, '2. rok (2023)', '2023-01-01', '2023-12-31', '871900.00', '434500.00', '0.00', '2893.35', '0.00', '0.67', '330804.00', '263294.85', '37.94', '60.60', '541096.00', '171205.15', '81543.19', '145409.08'),
(44538, 2, 2023, 235, 'TAČR THETA IV - COGEN mikroKVET_CZ', 738, '2. rok (2023 poslední)', '2023-01-01', '2023-12-31', '794700.00', '83800.00', '0.00', '30000.00', '0.00', '35.80', '796812.00', '2730000.00', '100.27', '3257.76', '-2112.00', '-2646200.00', '79470.00', '30342.50'),
(44539, 2, 2023, 237, 'TAČR THETA IV - FlexiCoMix Regulus', 742, '2. rok (2023)', '2023-01-01', '2023-12-31', '949400.00', '203000.00', '0.00', '0.00', '0.00', '0.00', '868656.00', '0.00', '91.50', '0.00', '80744.00', '203000.00', '86865.60', '28810.00'),
(44540, 2, 2023, 246, 'TAČR THETA IV - Power2Heat', 775, '2. rok (2023)', '2023-01-01', '2023-12-31', '354500.00', '106000.00', '0.00', '0.00', '0.00', '0.00', '595920.00', '0.00', '168.10', '0.00', '-241420.00', '106000.00', '0.00', '0.00'),
(44541, 2, 2023, 236, 'TAČR THETA IV - tribo-RVE (Šlechta)', 740, '2. rok (2023 poslední)', '2023-01-01', '2023-12-31', '764000.00', '263800.00', '0.00', '2305.26', '0.00', '0.87', '554448.00', '209778.66', '72.57', '79.52', '209552.00', '54021.34', '99800.64', '84011.16'),
(44643, 5, 2023, 272, 'CRAFT HE - Vácha', 883, 'rok 2023', '2023-01-01', '2023-12-31', '1174750.00', '373325.00', '0.00', '0.00', '0.00', '0.00', '204468.00', '0.00', '17.41', '0.00', '970282.00', '373325.00', '0.00', '0.00'),
(44644, 5, 2023, 210, 'H2020 - ARV', 663, 'etapa 1b - rok 2023', '2023-01-01', '2023-06-30', '2294578.13', '2771875.00', '0.00', '0.00', '0.00', '0.00', '424488.00', '0.00', '18.50', '0.00', '1870090.13', '2771875.00', '0.00', '0.00'),
(44645, 5, 2023, 210, 'H2020 - ARV', 1133, 'etapa 2a - rok 2023', '2023-07-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '424488.00', '0.00', '0.00', '0.00', '-424488.00', '0.00', '0.00', '0.00'),
(44646, 5, 2023, 105, 'H2020 - PLURAL', 304, 'Etapa 2b (do 09/2023)', '2023-01-01', '2023-09-30', '739284.25', '1068750.00', '0.00', '3478.97', '0.00', '0.33', '30636.00', '236533.72', '4.14', '22.13', '708648.25', '832216.28', '0.00', '0.00'),
(44647, 5, 2023, 105, 'H2020 - PLURAL', 305, 'Etapa 3a (10-12/2023)', '2023-10-01', '2023-12-31', '246428.00', '356250.00', '0.00', '0.00', '0.00', '0.00', '10212.00', '0.00', '4.14', '0.00', '236216.00', '356250.00', '0.00', '0.00'),
(44648, 5, 2023, 81, 'H2020 - SPARCS', 219, '3b etapa - 01/2023-09/2023', '2023-01-01', '2023-09-30', '325660.50', '0.00', '0.00', '0.00', '0.00', '0.00', '28512.00', '0.00', '8.76', '0.00', '297148.50', '0.00', '0.00', '0.00'),
(44649, 5, 2023, 81, 'H2020 - SPARCS', 220, '4a etapa (10/2023 - 12/2023)', '2023-10-01', '2023-12-31', '95931.00', '0.00', '0.00', '0.00', '0.00', '0.00', '9504.00', '0.00', '9.91', '0.00', '86427.00', '0.00', '0.00', '0.00'),
(44650, 5, 2023, 375, 'Mzdový Fond RP5', 1174, '2023', '2023-01-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44651, 5, 2023, 173, 'OP PIK Energocentrum II SCADA BI', 550, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '401400.00', '0.00', '0.00', '0.00', '0.00', '0.00', '381330.00', '0.00', '95.00', '0.00', '20070.00', '0.00', '57199.50', '10102.11'),
(44652, 5, 2023, 178, 'OP PIK EXCON', 575, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '418553.33', '0.00', '0.00', '0.00', '0.00', '0.00', '381330.00', '0.00', '91.11', '0.00', '37223.33', '0.00', '57199.50', '13938.87'),
(44653, 5, 2023, 258, 'OP PIK IX EXPECT-IT II', 818, 'Etapa 2b (01 - 05/2023)', '2023-01-01', '2023-05-31', '1015247.64', '90909.09', '0.00', '0.00', '0.00', '0.00', '525030.00', '0.00', '51.71', '0.00', '490217.64', '90909.09', '78754.50', '29348.73'),
(44654, 5, 2023, 250, 'OP PIK IX KARBOX II', 829, 'Etapa 2b (01 - 05/2023)', '2023-01-01', '2023-05-31', '701466.18', '0.00', '0.00', '0.00', '0.00', '0.00', '548580.00', '0.00', '78.20', '0.00', '152886.18', '0.00', '82287.00', '0.00'),
(44655, 5, 2023, 260, 'OP PIK IX RoboPID', 825, 'Etapa 2b (01 - 05/2023)', '2023-01-01', '2023-05-31', '1030260.00', '71875.00', '0.00', '0.00', '0.00', '0.00', '1386235.00', '0.00', '134.55', '0.00', '-355975.00', '71875.00', '154539.00', '23180.81'),
(44656, 5, 2023, 256, 'OP PIK IX Softlink II', 810, 'etapa 2b (01 - 05/2023)', '2023-01-01', '2023-05-31', '791092.27', '145454.55', '0.00', '90636.26', '0.00', '62.31', '789565.00', '3397915.62', '99.81', '2336.07', '1527.27', '-3252461.07', '118434.75', '39617.71'),
(44657, 5, 2023, 174, 'OP PIK LASSO', 555, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '252915.00', '0.00', '0.00', '0.00', '0.00', '0.00', '314430.00', '0.00', '124.32', '0.00', '-61515.00', '0.00', '37937.25', '5984.88'),
(44658, 5, 2023, 220, 'OP PIK SANS SOUCI', 697, 'Etapa 2b (01 - 05/2023)', '2023-01-01', '2023-05-31', '1000632.86', '0.00', '0.00', '0.00', '0.00', '0.00', '1454070.00', '0.00', '145.32', '0.00', '-453437.14', '0.00', '150094.93', '22514.20'),
(44659, 5, 2023, 185, 'OP PIK Senzor viskozity', 602, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '387102.08', '0.00', '0.00', '0.00', '0.00', '0.00', '509015.00', '0.00', '131.49', '0.00', '-121912.92', '0.00', '58065.31', '8709.75'),
(44660, 5, 2023, 215, 'OP PIK StructureGuard', 689, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '1283940.56', '31555.56', '0.00', '0.00', '0.00', '0.00', '4154980.00', '0.00', '323.61', '0.00', '-2871039.44', '31555.56', '192591.08', '35586.31'),
(44661, 5, 2023, 47, 'OP VVV - CAP', 1134, '2023 (poslední po prodloužení)', '2023-01-01', '2023-04-30', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '767284.00', '0.00', '0.00', '0.00', '-767284.00', '0.00', '0.00', '0.00'),
(44662, 5, 2023, 277, 'TAČR BETA - Energetické komunity - Vácha', 898, '2. rok (2023)', '2023-01-01', '2023-12-31', '1436739.00', '0.00', '0.00', '0.00', '0.00', '0.00', '528408.00', '0.00', '36.78', '0.00', '908331.00', '0.00', '0.00', '0.00'),
(44663, 5, 2023, 253, 'TAČR DOPRAVA - FICOS', 801, '2. rok (2023)', '2023-01-01', '2023-12-31', '1239300.00', '938000.00', '0.00', '0.00', '0.00', '0.00', '857328.00', '0.00', '69.18', '0.00', '381972.00', '938000.00', '0.00', '0.00'),
(44664, 5, 2023, 138, 'TAČR DOPRAVA - SOMKo', 414, '3. rok (2023)', '2023-01-01', '2023-12-31', '1100600.00', '114000.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '1100600.00', '114000.00', '0.00', '30365.00'),
(44665, 5, 2023, 230, 'TAČR ENERDIGIT DORES', 778, '2. rok (2023)', '2023-01-01', '2023-12-31', '1395630.00', '465210.00', '0.00', '0.00', '0.00', '0.00', '317700.00', '0.00', '22.76', '0.00', '1077930.00', '465210.00', '63540.00', '93042.00'),
(44666, 5, 2023, 161, 'TAČR ETA V - Obce mluví o vodě', 493, '3. rok (2023 - poslední)', '2023-01-01', '2023-12-31', '222750.00', '0.00', '0.00', '0.00', '0.00', '0.00', '76032.00', '0.00', '34.13', '0.00', '146718.00', '0.00', '15206.40', '11206.00'),
(44667, 5, 2023, 246, 'TAČR THETA IV - Power2Heat', 775, '2. rok (2023)', '2023-01-01', '2023-12-31', '558900.00', '0.00', '0.00', '0.00', '0.00', '0.00', '127788.00', '0.00', '22.86', '0.00', '431112.00', '0.00', '0.00', '0.00'),
(44668, 5, 2023, 143, 'TAČR TREND III - Timber Guard - Inosens', 434, '3. rok (2023 - poslední)', '2023-01-01', '2023-12-31', '2065100.00', '235147.00', '0.00', '0.00', '0.00', '0.00', '40848.00', '0.00', '1.98', '0.00', '2024252.00', '235147.00', '10212.00', '0.00'),
(44669, 6, 2023, 275, 'MetaMorph - TAČR KAPPA - InoCure', 893, '2.etapa - 2023', '2023-01-01', '2023-12-31', '3136000.00', '2432000.00', '0.00', '21067.79', '0.00', '0.87', '2652960.00', '1533735.11', '84.60', '63.06', '483040.00', '898264.89', '530592.00', '585147.02'),
(44670, 6, 2023, 248, 'MVČR SECTECH NANOPACH', 784, '2. rok (2023 poslední)', '2023-01-01', '2023-12-31', '266400.00', '50500.00', '0.00', '35000.00', '0.00', '69.31', '398568.00', '2548000.00', '149.61', '5045.54', '-132168.00', '-2497500.00', '0.00', '0.00'),
(44671, 6, 2023, 203, 'Mzdový Fond RP6', 859, 'Mzdový fond RP6 rok 2023', '2023-01-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44672, 6, 2023, 273, 'NextPhage - TAČR TREND III - InoCure', 888, '3 Etapa (2023 - poslední)', '2023-01-01', '2023-12-31', '583333.00', '490000.00', '0.00', '0.00', '0.00', '0.00', '1393728.00', '0.00', '238.92', '0.00', '-810395.00', '490000.00', '58333.30', '21000.00'),
(44673, 6, 2023, 91, 'TAČR ETA III - VVTO - Odorologie ', 232, '4. rok (poslední - do 03/2023)', '2023-01-01', '2023-03-31', '297937.00', '362278.21', '0.00', '0.00', '0.00', '0.00', '181767.00', '0.00', '61.01', '0.00', '116170.00', '362278.21', '36353.40', '0.00'),
(44674, 4, 2023, 110, 'GAČR - LEFM', 321, '3. rok (2023 - poslední)', '2023-01-01', '2023-12-31', '711000.00', '128000.00', '0.00', '0.00', '0.00', '0.00', '574956.00', '0.00', '80.87', '0.00', '136044.00', '128000.00', '0.00', '0.00'),
(44675, 4, 2023, 204, 'Mzdový Fond RP4', 862, 'Mzdový fond RP4 rok 2023', '2023-01-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44676, 4, 2023, 178, 'OP PIK EXCON', 575, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '354186.67', '80666.67', '0.00', '0.00', '0.00', '0.00', '282205.00', '0.00', '79.68', '0.00', '71981.67', '80666.67', '42330.75', '3447.77'),
(44677, 4, 2023, 177, 'OP PIK FASHEX / Dekmetal', 570, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '167500.00', '0.00', '0.00', '0.00', '0.00', '0.00', '160560.00', '0.00', '95.86', '0.00', '6940.00', '0.00', '24084.00', '0.00'),
(44678, 4, 2023, 258, 'OP PIK IX EXPECT-IT II', 818, 'Etapa 2b (01 - 05/2023)', '2023-01-01', '2023-05-31', '289141.75', '0.00', '0.00', '0.00', '0.00', '0.00', '397385.00', '0.00', '137.44', '0.00', '-108243.25', '0.00', '43371.26', '0.00'),
(44679, 4, 2023, 215, 'OP PIK StructureGuard', 689, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '297675.00', '0.00', '0.00', '0.00', '0.00', '0.00', '726755.00', '0.00', '244.14', '0.00', '-429080.00', '0.00', '44651.25', '0.00'),
(44680, 4, 2023, 200, 'OP PIK ZdrOk / VEKRA', 634, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44681, 4, 2023, 253, 'TAČR DOPRAVA - FICOS', 801, '2. rok (2023)', '2023-01-01', '2023-12-31', '797100.00', '0.00', '0.00', '0.00', '0.00', '0.00', '56616.00', '0.00', '7.10', '0.00', '740484.00', '0.00', '0.00', '0.00'),
(44682, 4, 2023, 228, 'TAČR TREND IV -  PReRaSyD ecokit', 721, '2. rok (2023)', '2023-01-01', '2023-12-31', '1081100.00', '660200.00', '0.00', '0.00', '0.00', '0.00', '1558392.00', '0.00', '144.15', '0.00', '-477292.00', '660200.00', '108110.00', '0.00'),
(44702, 0, 2023, 272, 'CRAFT HE - Vácha', 883, 'rok 2023', '2023-01-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '110640.00', '0.00', '0.00', '0.00', '-110640.00', '0.00', '0.00', '0.00'),
(44703, 0, 2023, 105, 'H2020 - PLURAL', 304, 'Etapa 2b (do 09/2023)', '2023-01-01', '2023-09-30', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '47493.00', '0.00', '0.00', '0.00', '-47493.00', '0.00', '0.00', '0.00'),
(44704, 0, 2023, 105, 'H2020 - PLURAL', 305, 'Etapa 3a (10-12/2023)', '2023-10-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '15831.00', '0.00', '0.00', '0.00', '-15831.00', '0.00', '0.00', '0.00'),
(44705, 0, 2023, 81, 'H2020 - SPARCS', 219, '3b etapa - 01/2023-09/2023', '2023-01-01', '2023-09-30', '419824.35', '165750.00', '0.00', '0.00', '0.00', '0.00', '373419.00', '0.00', '88.95', '0.00', '46405.35', '165750.00', '0.00', '0.00'),
(44706, 0, 2023, 81, 'H2020 - SPARCS', 220, '4a etapa (10/2023 - 12/2023)', '2023-10-01', '2023-12-31', '136575.45', '73312.50', '0.00', '0.00', '0.00', '0.00', '124473.00', '0.00', '91.14', '0.00', '12102.45', '73312.50', '0.00', '0.00'),
(44707, 0, 2023, 355, 'Interreg Europe LC Districts - Lump Sum Phase 2', 1132, 'Udžovací fáze', '2022-02-01', '2023-01-31', '0.00', '184775.00', '0.00', '96792.29', '0.00', '52.38', '0.00', '103930.36', '0.00', '56.25', '0.00', '80844.64', '0.00', '19748.30'),
(44708, 0, 2023, 357, 'Interreg RESINDUSTRY - Lump Sum phase 2', 1137, 'Udržovací fáze', '2022-08-01', '2023-07-31', '0.00', '1500257.70', '0.00', '95261.74', '0.00', '6.35', '0.00', '219405.90', '0.00', '14.62', '0.00', '1280851.80', '0.00', '56540.33'),
(44709, 0, 2023, 310, 'METEOPRESS Kordík OP PIK IX', 990, 'Etapa 2b (01 - 05/2023)', '2023-01-01', '2023-05-31', '735030.27', '0.00', '0.00', '0.00', '0.00', '0.00', '683285.00', '0.00', '92.96', '0.00', '51745.27', '0.00', '102492.75', '16538.15'),
(44710, 0, 2023, 279, 'NEB-STAR HE - Kuzmič', 905, '2.rok - 2023', '2023-01-01', '2023-12-31', '366675.00', '116675.00', '0.00', '0.00', '0.00', '0.00', '324648.00', '0.00', '88.54', '0.00', '42027.00', '116675.00', '0.00', '0.00'),
(44711, 0, 2023, 266, 'OP PIK Alimex', 1028, 'Etapa 2b (01 - 05/2023)', '2023-01-01', '2023-05-31', '2356458.82', '235294.12', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2356458.82', '235294.12', '0.00', '53019.71'),
(44712, 0, 2023, 263, 'OP PIK Alpha Analytics FIT', 844, 'Etapa 2b (01 - 05/2023)', '2023-01-01', '2023-05-31', '640901.82', '0.00', '0.00', '0.00', '0.00', '0.00', '466640.00', '0.00', '72.81', '0.00', '174261.82', '0.00', '69996.00', '14420.25'),
(44713, 0, 2023, 282, 'OP PIK IX CEBIA AUTOTRACER FIT', 903, 'Etapa 2b (01 - 05/2023)', '2023-01-01', '2023-05-31', '1336661.82', '0.00', '0.00', '0.00', '0.00', '0.00', '1078425.00', '0.00', '80.68', '0.00', '258236.82', '0.00', '161763.75', '30074.86'),
(44714, 0, 2023, 289, 'OP PIK IX CEBIA DIGITALIZACE VIN FIT', 939, 'E2 b (01 - 05/2023)', '2023-01-01', '2023-05-31', '1123920.00', '0.00', '0.00', '0.00', '0.00', '0.00', '1274445.00', '0.00', '113.39', '0.00', '-150525.00', '0.00', '168588.00', '25288.16'),
(44715, 0, 2023, 190, 'OP PIK MOB-Bars FSv', 620, 'etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '350480.00', '33333.33', '0.00', '0.00', '0.00', '0.00', '407840.00', '0.00', '116.37', '0.00', '-57360.00', '33333.33', '52572.00', '0.00'),
(44716, 0, 2023, 261, 'OP PIK TEAS_DMS FIT', 834, 'Etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '727871.82', '0.00', '0.00', '0.00', '0.00', '0.00', '755305.00', '0.00', '103.77', '0.00', '-27433.18', '0.00', '109180.77', '16377.05'),
(44717, 0, 2023, 262, 'OP PIK TEAS_Servis FIT', 839, 'Etapa 3b (01 - 05/2023)', '2023-01-01', '2023-05-31', '656958.18', '0.00', '0.00', '0.00', '0.00', '0.00', '814840.00', '0.00', '124.03', '0.00', '-157881.82', '0.00', '98543.73', '14781.49'),
(44718, 0, 2023, 47, 'OP VVV - CAP', 1134, '2023 (poslední po prodloužení)', '2023-01-01', '2023-04-30', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44719, 0, 2023, 169, 'Režie - finanční oddělení', 514, 'Rok 2023', '2023-01-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44720, 0, 2023, 170, 'Režie - marketing', 517, 'Rok 2023', '2023-01-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44721, 0, 2023, 98, 'Režie - ostatní', 1171, 'rok 2023', '2023-01-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '6694584.00', '0.00', '0.00', '0.00', '-6694584.00', '0.00', '0.00', '0.00'),
(44722, 0, 2023, 168, 'Režie - projektové oddělení', 511, 'Rok 2023', '2023-01-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44723, 0, 2023, 167, 'Režie - ředitel', 508, 'Rok 2023', '2023-01-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44724, 0, 2023, 94, 'Režie - správa budovy', 869, '4. etapa 2023', '2023-01-01', '2023-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '3379896.00', '0.00', '0.00', '0.00', '-3379896.00', '0.00', '0.00', '0.00'),
(44725, 0, 2023, 306, 'UNICO Kordík OP PIK IX', 976, 'Etapa 2b (01-05/2023)', '2023-01-01', '2023-05-31', '362598.13', '0.00', '0.00', '0.00', '0.00', '0.00', '894160.00', '0.00', '246.60', '0.00', '-531561.87', '0.00', '54389.72', '8158.43'),
(44726, 0, 2023, 335, 'Y Soft Kordík OP PIK ', 1069, 'Etapa 2b (01 - 04/2023)', '2023-01-01', '2023-04-30', '1477152.00', '0.00', '0.00', '0.00', '0.00', '0.00', '928244.00', '0.00', '62.84', '0.00', '548908.00', '0.00', '139236.60', '0.00'),
(44862, 2, 2022, 150, 'EUKI - Energy Efficiency Network', 460, '3. rok (poslední - do 11/2022)', '2022-01-01', '2022-11-30', '660688.81', '904824.42', '709394.00', '124832.51', '107.37', '13.80', '709394.00', '112349.26', '107.37', '12.42', '-48705.20', '792475.16', '66068.88', '22334.93'),
(44863, 2, 2022, 210, 'H2020 - ARV', 662, 'etapa 1a - rok 2022', '2022-01-01', '2022-12-31', '682171.88', '0.00', '46827.00', '39809.00', '6.86', '0.00', '46827.00', '39163.45', '6.86', '0.00', '635344.88', '-39163.45', '0.00', '0.00'),
(44864, 2, 2022, 105, 'H2020 - PLURAL', 302, 'Etapa 1c (01-03/2022)', '2022-01-01', '2022-03-31', '180163.00', '0.00', '180163.00', '0.00', '100.00', '0.00', '180163.00', '0.00', '100.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44865, 2, 2022, 105, 'H2020 - PLURAL', 303, 'Etapa 2a', '2022-04-01', '2022-12-31', '553644.75', '0.00', '430599.00', '89131.20', '77.78', '0.00', '430599.00', '87221.53', '77.78', '0.00', '123045.75', '-87221.53', '0.00', '0.00'),
(44866, 2, 2022, 80, 'H2020 - POWERSKIN PLUS', 242, '2b (1/22-9/22)', '2022-01-01', '2022-09-30', '0.00', '0.00', '0.00', '598.00', '0.00', '0.00', '0.00', '439.54', '0.00', '0.00', '0.00', '-439.54', '0.00', '0.00'),
(44867, 2, 2022, 80, 'H2020 - POWERSKIN PLUS', 243, '3a (10/22-12/22)', '2022-10-01', '2022-12-31', '847339.40', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '847339.40', '0.00', '0.00', '0.00'),
(44868, 2, 2022, 81, 'H2020 - SPARCS', 237, '2c Etapa (01/2022-03/2022)', '2022-01-01', '2022-03-31', '615.00', '0.00', '615.00', '0.00', '100.00', '0.00', '615.00', '0.00', '100.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44869, 2, 2022, 81, 'H2020 - SPARCS', 238, '3a etapa (04/2022-12/2022', '2022-04-01', '2022-12-31', '465749.03', '0.00', '36762.00', '16646.00', '7.89', '0.00', '36762.00', '16289.35', '7.89', '0.00', '428987.03', '-16289.35', '0.00', '0.00'),
(44870, 2, 2022, 67, 'INTERREG - Finerpol', 805, 'Prodloužení 10/2021-9/2022', '2021-10-01', '2022-10-31', '150000.00', '0.00', '344300.00', '6999.57', '229.53', '0.00', '344300.00', '5984.57', '229.53', '0.00', '-194300.00', '-5984.57', '22500.00', '0.00'),
(44871, 2, 2022, 72, 'Interreg LC-districts', 204, '5. semestr', '2021-08-01', '2022-01-31', '87104.00', '0.00', '87104.00', '0.00', '100.00', '0.00', '87104.00', '0.00', '100.00', '0.00', '0.00', '0.00', '13065.60', '0.00'),
(44872, 2, 2022, 85, 'Interreg RESINDUSTRY', 290, 'S5b (pouze 01/2022) - prázdné', '2022-01-01', '2022-01-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '46843.00', '0.00', '0.00', '0.00', '-46843.00', '0.00', '0.00', '0.00'),
(44873, 2, 2022, 85, 'Interreg RESINDUSTRY', 210, 'S6 (02/2022-07/2022)', '2022-02-01', '2022-07-31', '109046.00', '0.00', '321753.00', '7901.63', '295.06', '0.00', '321753.00', '4194.58', '295.06', '0.00', '-212707.00', '-4194.58', '16356.90', '1471.56'),
(44874, 2, 2022, 357, 'Interreg RESINDUSTRY - Lump Sum phase 2', 1137, 'Udržovací fáze', '2022-08-01', '2023-07-31', '0.00', '0.00', '0.00', '22391.00', '0.00', '0.00', '0.00', '21540.93', '0.00', '0.00', '0.00', '-21540.93', '0.00', '10126.90'),
(44875, 2, 2022, 255, 'Mzdový Fond RP2', 864, 'Mzdový fond RP2 rok 2022', '2022-01-01', '2022-12-31', '0.00', '0.00', '8088.00', '0.00', '0.00', '0.00', '8088.00', '0.00', '0.00', '0.00', '-8088.00', '0.00', '0.00', '0.00'),
(44876, 2, 2022, 62, 'NCK - RESOPT', 529, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '49500.00', '191480.73', '44008.00', '55958.98', '88.91', '29.22', '44008.00', '55051.54', '88.91', '28.75', '5492.00', '136429.19', '0.00', '0.00'),
(44877, 2, 2022, 171, 'OP PIK ALTEKO Zmrhal', 537, '2. etapa (01 - 09/2022)', '2022-01-01', '2022-09-30', '956862.00', '19406.96', '985144.00', '17889.00', '102.96', '92.18', '985144.00', '13148.82', '102.96', '67.75', '-28282.00', '6258.14', '277460.41', '23639.54'),
(44878, 2, 2022, 171, 'OP PIK ALTEKO Zmrhal', 539, 'etapa 3a (10-12/2022)', '2022-10-01', '2022-12-31', '1093955.18', '328179.25', '373328.68', '59220.00', '34.13', '18.05', '373328.68', '55558.48', '34.13', '16.93', '720626.50', '272620.77', '86580.62', '15556.18'),
(44879, 2, 2022, 181, 'OP PIK DH4.ENERGY / Feramat', 583, 'etapa 2 (01 - 09/2022)', '2022-01-01', '2022-09-30', '1494146.00', '176869.45', '1494146.00', '176869.45', '100.00', '100.00', '1494146.00', '130003.03', '100.00', '73.50', '0.00', '46866.42', '326169.84', '44303.91'),
(44880, 2, 2022, 181, 'OP PIK DH4.ENERGY / Feramat', 584, 'etapa 3a (10 - 12/2022)', '2022-10-01', '2022-12-31', '-24304.12', '48130.55', '242577.04', '0.00', '-998.09', '0.00', '242577.04', '0.00', '-998.09', '0.00', '-266881.16', '48130.55', '1310.34', '8267.82'),
(44881, 2, 2022, 172, 'OP PIK EMET', 542, 'etapa 1b (01-02/2022)', '2022-01-01', '2022-02-28', '292117.59', '0.00', '292117.59', '0.00', '100.00', '0.00', '292117.59', '0.00', '100.00', '0.00', '0.00', '0.00', '43817.64', '7850.92'),
(44882, 2, 2022, 172, 'OP PIK EMET', 544, '2. etapa (03-09/2022)', '2022-03-01', '2022-09-30', '902668.00', '1013813.28', '902668.00', '495525.20', '100.00', '48.88', '902668.00', '339312.61', '100.00', '33.47', '0.00', '674500.67', '191861.13', '86505.05'),
(44883, 2, 2022, 172, 'OP PIK EMET', 545, 'Etapa 3a (10 - 12/2022)', '2022-10-01', '2022-12-31', '532375.13', '632580.55', '481394.91', '147336.00', '90.42', '23.29', '481394.91', '138226.35', '90.42', '21.85', '50980.22', '494354.20', '84180.33', '28088.53'),
(44884, 2, 2022, 177, 'OP PIK FASHEX / Dekmetal', 567, 'etapa 1b (01/2022)', '2022-01-01', '2022-01-31', '106165.10', '3376.00', '106165.10', '3376.00', '100.00', '100.00', '106165.10', '273.73', '100.00', '8.11', '0.00', '3102.27', '19873.21', '3102.95'),
(44885, 2, 2022, 177, 'OP PIK FASHEX / Dekmetal', 568, 'etapa 2 (02 - 09/2022)', '2022-02-01', '2022-09-30', '1014304.00', '100768.40', '1014304.00', '100768.40', '100.00', '100.00', '1014304.00', '71625.33', '100.00', '71.08', '0.00', '29143.07', '212742.28', '36312.68'),
(44886, 2, 2022, 177, 'OP PIK FASHEX / Dekmetal', 569, 'etapa 3a (10 - 12/2022)', '2022-10-01', '2022-12-31', '207365.75', '13945.57', '254377.11', '32171.52', '122.67', '230.69', '254377.11', '30182.38', '122.67', '216.43', '-47011.36', '-16236.81', '57163.75', '11810.16'),
(44887, 2, 2022, 250, 'OP PIK IX KARBOX II', 826, 'Etapa 1b (01 - 09/2022)', '2022-01-01', '2022-09-30', '2029810.00', '398504.53', '2029810.00', '316906.40', '100.00', '79.52', '2029810.00', '232933.34', '100.00', '58.45', '0.00', '165571.19', '423387.59', '132044.87'),
(44888, 2, 2022, 250, 'OP PIK IX KARBOX II', 828, 'Etapa 2a (10 - 12/2022)', '2022-10-01', '2022-12-31', '2041045.29', '1221695.47', '1504505.49', '942382.92', '73.71', '77.14', '1504505.49', '884116.22', '73.71', '72.37', '536539.80', '337579.25', '267682.33', '164985.72'),
(44889, 2, 2022, 259, 'OP PIK IX MiniBio', 820, 'Etapa 1b (01 - 09/2022)', '2022-01-01', '2022-09-30', '109048.00', '408787.07', '109048.00', '408787.07', '100.00', '100.00', '109048.00', '300467.70', '100.00', '73.50', '0.00', '108319.37', '35600.31', '77170.14'),
(44890, 2, 2022, 259, 'OP PIK IX MiniBio', 821, 'Etapa 2a (10 - 12/2022)', '2022-10-01', '2022-12-31', '1793176.47', '342112.93', '577462.36', '127903.63', '32.20', '37.39', '577462.36', '119995.46', '32.20', '35.07', '1215714.11', '222117.47', '91961.99', '28699.31'),
(44891, 2, 2022, 99, 'OP PIK Kotel GTP', 283, '2b (jen 01/2022)', '2022-01-01', '2022-01-31', '-33751.22', '0.00', '-33751.22', '0.00', '100.00', '0.00', '-33751.22', '0.00', '100.00', '0.00', '0.00', '0.00', '-2762.66', '2901.78'),
(44892, 2, 2022, 99, 'OP PIK Kotel GTP', 284, '3 (02/2022 - 12/2022)', '2022-02-01', '2022-12-31', '1851000.00', '1753726.43', '1790793.65', '1755780.48', '96.75', '100.12', '1790793.65', '1724704.72', '96.75', '98.35', '60206.35', '29021.71', '369259.40', '290625.23'),
(44893, 2, 2022, 199, 'OP PIK Multi-Heat / TECHTRANS', 627, 'etapa 2b (01 - 08/2022)', '2022-01-01', '2022-08-31', '1164937.48', '0.00', '1164937.48', '0.00', '100.00', '0.00', '1164937.48', '0.00', '100.00', '0.00', '0.00', '0.00', '199434.76', '19237.13'),
(44894, 2, 2022, 199, 'OP PIK Multi-Heat / TECHTRANS', 628, 'etapa 3a (09 - 12/2022)', '2022-09-01', '2022-12-31', '206774.58', '35001.72', '526351.23', '0.00', '254.55', '0.00', '526351.23', '0.00', '254.55', '0.00', '-319576.65', '35001.72', '38595.96', '12655.65'),
(44895, 2, 2022, 183, 'OP PIK QUANTUM', 590, 'etapa 1b (01/2022)', '2022-01-01', '2022-01-31', '11842.49', '39800.18', '11842.49', '39800.18', '100.00', '100.00', '11842.49', '3227.04', '100.00', '8.11', '0.00', '36573.14', '16570.64', '2627.71'),
(44896, 2, 2022, 183, 'OP PIK QUANTUM', 591, 'etapa 2 (02 - 09/2022)', '2022-02-01', '2022-09-30', '620318.00', '85208.47', '620318.00', '85208.47', '100.00', '100.00', '620318.00', '60565.46', '100.00', '71.08', '0.00', '24643.01', '212374.55', '26234.14'),
(44897, 2, 2022, 183, 'OP PIK QUANTUM', 592, 'etapa 3a (10 - 12/2022)', '2022-10-01', '2022-12-31', '662182.00', '79304.37', '391051.31', '54786.96', '59.05', '69.08', '391051.31', '51399.53', '59.05', '64.81', '271130.69', '27904.84', '73861.39', '14140.92'),
(44898, 2, 2022, 142, 'TAČR KAPPA - DEXPAND', 428, '3. rok (2022)', '2022-01-01', '2022-12-31', '1240090.00', '287010.53', '1144848.00', '125105.75', '92.32', '43.59', '1144848.00', '123077.01', '92.32', '42.88', '95242.00', '163933.52', '0.00', '0.00'),
(44899, 2, 2022, 71, 'TAČR THÉTA II Rošt', 124, '4. etapa (do 07/2022) - poslední', '2022-01-01', '2022-07-31', '520118.00', '372148.24', '498987.00', '393279.24', '95.94', '105.68', '498987.00', '224231.17', '95.94', '60.25', '21131.00', '147917.07', '94807.53', '42603.92'),
(44900, 2, 2022, 97, 'TAČR THETA III Data4energy', 266, '3. rok (2022)', '2022-01-01', '2022-12-31', '670157.80', '378403.81', '552968.00', '418822.98', '82.51', '110.68', '552968.00', '412031.26', '82.51', '108.89', '117189.80', '-33627.45', '55296.80', '56220.38'),
(44901, 2, 2022, 234, 'TAČR THETA IV - BIOM_Nástřiky', 734, '1. rok (2022)', '2022-01-01', '2022-12-31', '871900.00', '238000.00', '492335.00', '299260.07', '56.47', '125.74', '492335.00', '294407.20', '56.47', '123.70', '379565.00', '-56407.20', '121360.58', '127064.59'),
(44902, 2, 2022, 235, 'TAČR THETA IV - COGEN mikroKVET_CZ', 737, '1. rok (2022)', '2022-01-01', '2022-12-31', '794700.00', '91500.00', '786041.00', '5358.00', '98.91', '5.86', '786041.00', '5271.11', '98.91', '5.76', '8659.00', '86228.89', '78604.10', '22682.11'),
(44903, 2, 2022, 237, 'TAČR THETA IV - FlexiCoMix Regulus', 741, '1. rok (2022)', '2022-01-01', '2022-12-31', '686100.00', '195000.00', '256855.00', '120738.17', '37.44', '61.92', '256855.00', '118780.25', '37.44', '60.91', '429245.00', '76219.75', '25685.50', '33905.53'),
(44904, 2, 2022, 246, 'TAČR THETA IV - Power2Heat', 774, '1. rok (2022)', '2022-01-01', '2022-12-31', '354500.00', '60000.00', '166268.00', '15938.00', '46.90', '26.56', '166268.00', '15679.55', '46.90', '26.13', '188232.00', '44320.45', '0.00', '0.00'),
(44905, 2, 2022, 236, 'TAČR THETA IV - tribo-RVE (Šlechta)', 739, '1. rok (2022)', '2022-01-01', '2022-12-31', '764000.00', '257200.00', '646973.00', '294052.10', '84.68', '114.33', '646973.00', '289283.69', '84.68', '112.47', '117027.00', '-32083.69', '116455.14', '92250.00'),
(44906, 2, 2022, 93, 'TAČR ZETA IV - WH-CarBatt', 258, '3. rok - 2022 (do 06 - poslední etapa)', '2022-01-01', '2022-06-30', '593080.00', '809865.31', '523561.00', '829794.31', '88.28', '102.46', '523561.00', '403590.27', '88.28', '49.83', '69519.00', '406275.04', '26178.05', '31728.01'),
(44950, 3, 2022, 334, 'EuroTeQ TF II - Maierová', 1067, '1.etapa - 2022', '2022-07-01', '2022-12-31', '49680.00', '24000.00', '33120.00', '0.00', '66.67', '0.00', '33120.00', '0.00', '66.67', '0.00', '16560.00', '24000.00', '1656.00', '0.00'),
(44951, 3, 2022, 105, 'H2020 - PLURAL', 302, 'Etapa 1c (01-03/2022)', '2022-01-01', '2022-03-31', '274306.00', '0.00', '274306.00', '24810.57', '100.00', '0.00', '274306.00', '5965.15', '100.00', '0.00', '0.00', '-5965.15', '0.00', '0.00'),
(44952, 3, 2022, 105, 'H2020 - PLURAL', 303, 'Etapa 2a', '2022-04-01', '2022-12-31', '1000451.00', '0.00', '813071.00', '161923.95', '81.27', '0.00', '813071.00', '158454.67', '81.27', '0.00', '187380.00', '-158454.67', '0.00', '0.00'),
(44953, 3, 2022, 265, 'Mzdový Fond RP3', 851, '2022', '2022-01-01', '2022-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44954, 3, 2022, 62, 'NCK - RESOPT', 529, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '237000.00', '0.00', '236267.00', '14595.00', '99.69', '0.00', '236267.00', '14358.32', '99.69', '0.00', '733.00', '-14358.32', '0.00', '0.00'),
(44955, 3, 2022, 172, 'OP PIK EMET', 542, 'etapa 1b (01-02/2022)', '2022-01-01', '2022-02-28', '111039.05', '0.00', '111039.05', '0.00', '100.00', '0.00', '111039.05', '0.00', '100.00', '0.00', '0.00', '0.00', '16655.86', '691.05'),
(44956, 3, 2022, 172, 'OP PIK EMET', 544, '2. etapa (03-09/2022)', '2022-03-01', '2022-09-30', '358636.00', '0.00', '358636.00', '518288.08', '100.00', '0.00', '358636.00', '354899.57', '100.00', '0.00', '0.00', '-354899.57', '68423.75', '3134.26'),
(44957, 3, 2022, 172, 'OP PIK EMET', 545, 'Etapa 3a (10 - 12/2022)', '2022-10-01', '2022-12-31', '637730.88', '0.00', '290076.93', '456295.16', '45.49', '0.00', '290076.93', '428082.84', '45.49', '0.00', '347653.95', '-428082.84', '105174.61', '647.36'),
(44958, 3, 2022, 173, 'OP PIK Energocentrum II SCADA BI', 548, 'etapa 2b (01 - 08/2022)', '2022-01-01', '2022-08-31', '958004.35', '3276.15', '958004.35', '0.00', '100.00', '0.00', '958004.35', '0.00', '100.00', '0.00', '0.00', '3276.15', '207433.61', '26060.70'),
(44959, 3, 2022, 173, 'OP PIK Energocentrum II SCADA BI', 549, 'etapa 3a (09 - 12/2022)', '2022-09-01', '2022-12-31', '1710761.18', '54826.40', '547404.13', '0.00', '32.00', '0.00', '547404.13', '0.00', '32.00', '0.00', '1163357.05', '54826.40', '100996.49', '13030.35'),
(44960, 3, 2022, 188, 'OP PIK VIVA', 613, 'etapa 2 (01 - 09/2022)', '2022-01-01', '2022-09-30', '1090458.00', '259407.50', '1090458.00', '244212.52', '100.00', '94.14', '1090458.00', '179501.70', '100.00', '69.20', '0.00', '79905.80', '387571.31', '77656.85'),
(44961, 3, 2022, 188, 'OP PIK VIVA', 614, 'etapa 3a (10 - 12/2022)', '2022-10-01', '2022-12-31', '1604415.25', '160714.95', '833218.51', '101865.00', '51.93', '63.38', '833218.51', '95566.78', '51.93', '59.46', '771196.74', '65148.17', '151978.27', '24238.06'),
(44962, 3, 2022, 200, 'OP PIK ZdrOk / VEKRA', 632, 'etapa 2b (01 - 07/2022)', '2022-01-01', '2022-07-31', '717094.07', '317537.57', '717094.07', '23762.50', '100.00', '7.48', '717094.07', '13548.37', '100.00', '4.27', '0.00', '303989.20', '175820.83', '18236.18'),
(44963, 3, 2022, 200, 'OP PIK ZdrOk / VEKRA', 633, 'etapa 3a (08-12/2022)', '2022-08-01', '2022-12-31', '3075977.20', '1549962.43', '1008214.16', '31082.48', '32.78', '2.01', '1008214.16', '29902.44', '32.78', '1.93', '2067763.04', '1520059.99', '222766.96', '16059.64'),
(44964, 3, 2022, 12, 'TAČR THETA Větrací jednotka (Korado)', 226, '5. rok (2022) - poslední', '2022-01-01', '2022-06-30', '850403.32', '0.00', '848648.00', '33097.17', '99.79', '0.00', '848648.00', '16097.60', '99.79', '0.00', '1755.32', '-16097.60', '154878.26', '15795.47'),
(44965, 3, 2022, 122, 'TAČR TREND II - FullSpectraSun (Spectrasol)', 359, '3. rok (2022)', '2022-01-01', '2022-12-31', '518934.00', '154405.47', '522385.00', '139509.00', '100.67', '90.35', '522385.00', '137246.69', '100.67', '88.89', '-3451.00', '17158.78', '51893.40', '29496.42'),
(44966, 4, 2022, 110, 'GAČR - LEFM', 320, '2. rok (2022)', '2022-01-01', '2022-12-31', '734243.00', '436406.47', '727660.00', '369823.62', '99.10', '84.74', '727660.00', '363826.48', '99.10', '83.37', '6583.00', '72579.99', '0.00', '0.00'),
(44967, 4, 2022, 204, 'Mzdový Fond RP4', 861, 'Mzdový fond RP4 rok 2022', '2022-01-01', '2022-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44968, 4, 2022, 63, 'NCK - BIMIP', 525, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '0.00', '0.00', '276.00', '0.00', '0.00', '0.00', '276.00', '0.00', '0.00', '0.00', '-276.00', '0.00', '0.00', '0.00'),
(44969, 4, 2022, 65, 'NCK - MTS', 527, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '1258845.00', '567975.13', '1266353.00', '560464.84', '100.60', '98.68', '1266353.00', '551376.22', '100.60', '97.08', '-7508.00', '16598.91', '0.00', '0.00'),
(44970, 4, 2022, 77, 'NCK - STD4.0', 521, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '0.00', '103.34', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '103.34', '0.00', '0.00'),
(44971, 4, 2022, 178, 'OP PIK EXCON', 573, 'etapa 2b (01 - 08/2022)', '2022-01-01', '2022-08-31', '969000.56', '482314.77', '969000.56', '266741.26', '100.00', '55.30', '969000.56', '174433.16', '100.00', '36.17', '0.00', '307881.61', '183438.92', '31681.41'),
(44972, 4, 2022, 178, 'OP PIK EXCON', 574, 'etapa 3a (09 - 12/2022)', '2022-09-01', '2022-12-31', '584293.33', '188979.96', '191837.39', '0.00', '32.83', '0.00', '191837.39', '0.00', '32.83', '0.00', '392455.94', '188979.96', '69662.22', '2758.22'),
(44973, 4, 2022, 177, 'OP PIK FASHEX / Dekmetal', 567, 'etapa 1b (01/2022)', '2022-01-01', '2022-01-31', '-4.84', '0.00', '-4.84', '0.00', '100.00', '0.00', '-4.84', '0.00', '100.00', '0.00', '0.00', '0.00', '-0.73', '0.00'),
(44974, 4, 2022, 177, 'OP PIK FASHEX / Dekmetal', 568, 'etapa 2 (02 - 09/2022)', '2022-02-01', '2022-09-30', '238420.00', '0.00', '238420.00', '0.00', '100.00', '0.00', '238420.00', '0.00', '100.00', '0.00', '0.00', '0.00', '65853.28', '0.00'),
(44975, 4, 2022, 177, 'OP PIK FASHEX / Dekmetal', 569, 'etapa 3a (10 - 12/2022)', '2022-10-01', '2022-12-31', '210274.00', '0.00', '55645.13', '0.00', '26.46', '0.00', '55645.13', '0.00', '26.46', '0.00', '154628.87', '0.00', '25130.64', '0.00'),
(44976, 4, 2022, 258, 'OP PIK IX EXPECT-IT II', 816, 'Etapa 1b (01 - 06/2022)', '2022-01-01', '2022-06-30', '53596.00', '0.00', '53596.00', '0.00', '100.00', '0.00', '53596.00', '0.00', '100.00', '0.00', '0.00', '0.00', '8039.40', '0.00'),
(44977, 4, 2022, 258, 'OP PIK IX EXPECT-IT II', 817, 'Etapa 2a (07 - 12/2022)', '2022-07-01', '2022-12-31', '640344.27', '0.00', '177971.28', '0.00', '27.79', '0.00', '177971.28', '0.00', '27.79', '0.00', '462372.99', '0.00', '31967.41', '0.00'),
(44978, 4, 2022, 215, 'OP PIK StructureGuard', 687, 'etapa 2 (01 - 08/2022)', '2022-01-01', '2022-08-31', '704554.00', '0.00', '704554.00', '0.00', '100.00', '0.00', '704554.00', '0.00', '100.00', '0.00', '0.00', '0.00', '145571.55', '0.00'),
(44979, 4, 2022, 215, 'OP PIK StructureGuard', 688, 'etapa 3a (09 - 12/2022)', '2022-09-01', '2022-12-31', '902891.00', '0.00', '338814.70', '0.00', '37.53', '0.00', '338814.70', '0.00', '37.53', '0.00', '564076.30', '0.00', '58075.51', '0.00'),
(44980, 4, 2022, 200, 'OP PIK ZdrOk / VEKRA', 632, 'etapa 2b (01 - 07/2022)', '2022-01-01', '2022-07-31', '156474.00', '0.00', '156474.00', '0.00', '100.00', '0.00', '156474.00', '0.00', '100.00', '0.00', '0.00', '0.00', '25246.63', '0.00'),
(44981, 4, 2022, 200, 'OP PIK ZdrOk / VEKRA', 633, 'etapa 3a (08-12/2022)', '2022-08-01', '2022-12-31', '153870.00', '0.00', '200498.00', '0.00', '130.30', '0.00', '200498.00', '0.00', '130.30', '0.00', '-46628.00', '0.00', '23080.50', '0.00'),
(44982, 4, 2022, 253, 'TAČR DOPRAVA - FICOS', 800, '1. rok (2022)', '2022-01-01', '2022-12-31', '797100.00', '0.00', '312189.00', '111846.50', '39.17', '0.00', '312189.00', '110032.77', '39.17', '0.00', '484911.00', '-110032.77', '0.00', '0.00'),
(44983, 4, 2022, 228, 'TAČR TREND IV -  PReRaSyD ecokit', 720, '1. rok (2022)', '2022-01-01', '2022-12-31', '1052700.00', '130000.00', '991383.00', '121625.83', '94.18', '93.56', '991383.00', '119653.52', '94.18', '92.04', '61317.00', '10346.48', '99138.30', '11965.35'),
(44984, 4, 2022, 68, 'TRIO Zlín', 173, '4. etapa (do 31.3. x žádost o prodloužení 30.6.22))', '2022-01-01', '2022-06-30', '465445.25', '150153.90', '464069.96', '149071.19', '99.70', '99.28', '464069.96', '72504.33', '99.70', '48.29', '1375.29', '77649.57', '0.00', '0.00'),
(44985, 5, 2022, 301, 'Asistenční voucher (pro Interreg CE: Clear in cities)', 970, 'Realizace 1.1.-23.2.2022', '2022-01-01', '2022-04-30', '0.00', '0.00', '231409.00', '0.00', '0.00', '0.00', '231409.00', '0.00', '0.00', '0.00', '-231409.00', '0.00', '0.00', '1964.31'),
(44986, 5, 2022, 272, 'CRAFT HE - Vácha', 882, 'rok 2022', '2022-05-01', '2022-12-31', '783175.00', '248875.00', '217616.00', '63641.60', '27.79', '25.57', '217616.00', '62114.46', '27.79', '24.96', '565559.00', '186760.54', '0.00', '0.00'),
(44987, 5, 2022, 150, 'EUKI - Energy Efficiency Network', 460, '3. rok (poslední - do 11/2022)', '2022-01-01', '2022-11-30', '125028.58', '0.00', '114943.00', '0.00', '91.93', '0.00', '114943.00', '0.00', '91.93', '0.00', '10085.58', '0.00', '11494.30', '0.00'),
(44988, 5, 2022, 210, 'H2020 - ARV', 662, 'etapa 1a - rok 2022', '2022-01-01', '2022-12-31', '2294578.13', '2771875.00', '784214.00', '483442.65', '34.18', '17.44', '784214.00', '475603.04', '34.18', '17.16', '1510364.13', '2296271.96', '0.00', '0.00'),
(44989, 5, 2022, 105, 'H2020 - PLURAL', 302, 'Etapa 1c (01-03/2022)', '2022-01-01', '2022-03-31', '169051.00', '99282.45', '169051.00', '150723.51', '100.00', '151.81', '169051.00', '36238.14', '100.00', '36.50', '0.00', '63044.31', '0.00', '0.00'),
(44990, 5, 2022, 105, 'H2020 - PLURAL', 303, 'Etapa 2a', '2022-04-01', '2022-12-31', '896731.50', '255623.37', '301042.00', '166918.10', '33.57', '65.30', '301042.00', '163341.82', '33.57', '63.90', '595689.50', '92281.55', '0.00', '0.00'),
(44991, 5, 2022, 80, 'H2020 - POWERSKIN PLUS', 242, '2b (1/22-9/22)', '2022-01-01', '2022-09-30', '13011.00', '0.00', '13011.00', '0.00', '100.00', '0.00', '13011.00', '0.00', '100.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44992, 5, 2022, 81, 'H2020 - SPARCS', 237, '2c Etapa (01/2022-03/2022)', '2022-01-01', '2022-03-31', '51273.00', '0.00', '51273.00', '0.00', '100.00', '0.00', '51273.00', '0.00', '100.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44993, 5, 2022, 81, 'H2020 - SPARCS', 238, '3a etapa (04/2022-12/2022', '2022-04-01', '2022-12-31', '389675.90', '0.00', '30709.00', '4109.56', '7.88', '0.00', '30709.00', '4021.51', '7.88', '0.00', '358966.90', '-4021.51', '0.00', '0.00'),
(44994, 5, 2022, 375, 'Mzdový Fond RP5', 1173, '2022', '2022-12-01', '2022-12-31', '0.00', '0.00', '44089.00', '0.00', '0.00', '0.00', '44089.00', '0.00', '0.00', '0.00', '-44089.00', '0.00', '0.00', '0.00'),
(44995, 5, 2022, 76, 'NCK - CONAI', 523, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '442595.00', '73669.32', '432623.00', '95297.06', '97.75', '129.36', '432623.00', '93751.70', '97.75', '127.26', '9972.00', '-20082.38', '0.00', '0.00'),
(44996, 5, 2022, 62, 'NCK - RESOPT', 529, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '591000.00', '0.00', '574075.00', '130764.40', '97.14', '0.00', '574075.00', '128643.90', '97.14', '0.00', '16925.00', '-128643.90', '0.00', '0.00'),
(44997, 5, 2022, 279, 'NEB-STAR HE - Kuzmič', 904, '1.rok - 2022', '2022-10-01', '2022-12-31', '0.00', '0.00', '2696.00', '25515.98', '0.00', '0.00', '2696.00', '23938.35', '0.00', '0.00', '-2696.00', '-23938.35', '0.00', '0.00'),
(44998, 5, 2022, 173, 'OP PIK Energocentrum II SCADA BI', 548, 'etapa 2b (01 - 08/2022)', '2022-01-01', '2022-08-31', '376606.96', '0.00', '376606.96', '3276.15', '100.00', '0.00', '376606.96', '2142.41', '100.00', '0.00', '0.00', '-2142.41', '63559.69', '16163.38'),
(44999, 5, 2022, 173, 'OP PIK Energocentrum II SCADA BI', 549, 'etapa 3a (09 - 12/2022)', '2022-09-01', '2022-12-31', '387000.06', '0.00', '379308.00', '7095.35', '98.01', '0.00', '379308.00', '6760.25', '98.01', '0.00', '7692.06', '-6760.25', '56896.20', '8081.69'),
(45000, 5, 2022, 178, 'OP PIK EXCON', 573, 'etapa 2b (01 - 08/2022)', '2022-01-01', '2022-08-31', '422620.52', '0.00', '422620.52', '215573.51', '100.00', '0.00', '422620.52', '140972.45', '100.00', '0.00', '0.00', '-140972.45', '73948.56', '22302.22'),
(45001, 5, 2022, 178, 'OP PIK EXCON', 574, 'etapa 3a (09 - 12/2022)', '2022-09-01', '2022-12-31', '1262154.67', '0.00', '352066.18', '7457.63', '27.89', '0.00', '352066.18', '7105.42', '27.89', '0.00', '910088.49', '-7105.42', '54574.75', '11151.09'),
(45002, 5, 2022, 258, 'OP PIK IX EXPECT-IT II', 816, 'Etapa 1b (01 - 06/2022)', '2022-01-01', '2022-06-30', '696672.00', '150000.00', '696672.00', '150000.00', '100.00', '100.00', '696672.00', '72956.08', '100.00', '48.64', '0.00', '77043.92', '105217.97', '30153.49'),
(45003, 5, 2022, 258, 'OP PIK IX EXPECT-IT II', 817, 'Etapa 2a (07 - 12/2022)', '2022-07-01', '2022-12-31', '1739922.34', '209090.91', '1253804.41', '157955.25', '72.06', '75.54', '1253804.41', '152941.90', '72.06', '73.15', '486117.93', '56149.01', '215672.25', '58159.77'),
(45004, 5, 2022, 250, 'OP PIK IX KARBOX II', 826, 'Etapa 1b (01 - 09/2022)', '2022-01-01', '2022-09-30', '588712.00', '0.00', '588712.00', '81598.13', '100.00', '0.00', '588712.00', '59976.46', '100.00', '0.00', '0.00', '-59976.46', '88306.80', '0.00'),
(45005, 5, 2022, 250, 'OP PIK IX KARBOX II', 828, 'Etapa 2a (10 - 12/2022)', '2022-10-01', '2022-12-31', '1094806.83', '0.00', '649762.00', '6547.94', '59.35', '0.00', '649762.00', '6143.09', '59.35', '0.00', '445044.83', '-6143.09', '97464.30', '0.00'),
(45006, 5, 2022, 260, 'OP PIK IX RoboPID', 823, 'Etapa 1b (01 - 09/2022)', '2022-01-01', '2022-09-30', '1295416.00', '52635.00', '1295416.00', '52635.00', '100.00', '100.00', '1295416.00', '38687.91', '100.00', '73.50', '0.00', '13947.09', '220783.40', '57157.60'),
(45007, 5, 2022, 260, 'OP PIK IX RoboPID', 824, 'Etapa 2a (10 - 12/2022)', '2022-10-01', '2022-12-31', '2619572.00', '125490.00', '1105910.25', '38872.00', '42.22', '30.98', '1105910.25', '36468.58', '42.22', '29.06', '1513661.75', '89021.42', '168490.29', '19378.77'),
(45008, 5, 2022, 256, 'OP PIK IX Softlink II', 808, 'etapa 1b (01 - 06/2022)', '2022-01-01', '2022-06-30', '849396.00', '67291.11', '849396.00', '67291.11', '100.00', '100.00', '849396.00', '32728.64', '100.00', '48.64', '0.00', '34562.47', '127781.36', '15589.02'),
(45009, 5, 2022, 256, 'OP PIK IX Softlink II', 809, 'etapa 2a (07 - 12/2022)', '2022-07-01', '2022-12-31', '1049225.73', '407254.34', '1052230.14', '302618.76', '100.29', '74.31', '1052230.14', '293013.93', '100.29', '71.95', '-3004.41', '114240.41', '169674.72', '65311.52'),
(45010, 5, 2022, 174, 'OP PIK LASSO', 553, 'etapa 2b (01 - 07/2022)', '2022-01-01', '2022-07-31', '494121.58', '0.00', '494121.58', '0.00', '100.00', '0.00', '494121.58', '0.00', '100.00', '0.00', '0.00', '0.00', '93417.55', '8378.83'),
(45011, 5, 2022, 174, 'OP PIK LASSO', 554, 'etapa 3a (08 - 12/2022)', '2022-08-01', '2022-12-31', '133589.00', '0.00', '395460.49', '0.00', '296.03', '0.00', '395460.49', '0.00', '296.03', '0.00', '-261871.49', '0.00', '27351.86', '5984.88'),
(45012, 5, 2022, 220, 'OP PIK SANS SOUCI', 695, 'Etapa 1b (01- 06/2022)', '2022-01-01', '2022-06-30', '1083698.46', '262306.96', '1083698.46', '262306.96', '100.00', '100.00', '1083698.46', '127579.25', '100.00', '48.64', '0.00', '134727.71', '181973.16', '46153.92'),
(45013, 5, 2022, 220, 'OP PIK SANS SOUCI', 696, 'Etapa 2a (07 - 12/2022)', '2022-07-01', '2022-12-31', '2502429.15', '594218.24', '1568856.50', '454134.53', '62.69', '76.43', '1568856.50', '439720.74', '62.69', '74.00', '933572.65', '154497.50', '263380.98', '92975.15'),
(45014, 5, 2022, 185, 'OP PIK Senzor viskozity', 599, 'etapa 1b (01/2022)', '2022-01-01', '2022-01-31', '54229.88', '0.00', '54229.88', '0.00', '100.00', '0.00', '54229.88', '0.00', '100.00', '0.00', '0.00', '0.00', '8744.61', '1741.95'),
(45015, 5, 2022, 185, 'OP PIK Senzor viskozity', 600, 'etapa 2 (02 - 09/2022)', '2022-02-01', '2022-09-30', '893180.00', '55425.58', '893180.00', '55425.58', '100.00', '100.00', '893180.00', '39396.03', '100.00', '71.08', '0.00', '16029.55', '152351.74', '19845.01'),
(45016, 5, 2022, 185, 'OP PIK Senzor viskozity', 601, 'etapa 3a (10 - 12/2022)', '2022-10-01', '2022-12-31', '125879.92', '213566.42', '464460.83', '780.78', '368.97', '0.37', '464460.83', '732.51', '368.97', '0.34', '-338580.91', '212833.91', '20268.16', '5335.73'),
(45017, 5, 2022, 215, 'OP PIK StructureGuard', 687, 'etapa 2 (01 - 08/2022)', '2022-01-01', '2022-08-31', '1897484.00', '135123.56', '1897484.00', '135123.56', '100.00', '100.00', '1897484.00', '88362.90', '100.00', '65.39', '0.00', '46760.66', '349178.42', '94306.59'),
(45018, 5, 2022, 215, 'OP PIK StructureGuard', 688, 'etapa 3a (09 - 12/2022)', '2022-09-01', '2022-12-31', '4352489.44', '441320.88', '2390363.30', '248185.89', '54.92', '56.24', '2390363.30', '236464.42', '54.92', '53.58', '1962126.14', '204856.46', '376913.20', '63938.71'),
(45019, 5, 2022, 47, 'OP VVV - CAP', 246, '2022 (prodlouženo do 04.2023)', '2022-01-01', '2022-12-31', '1235000.00', '310000.00', '1872937.00', '457748.43', '151.65', '147.66', '1872937.00', '450325.48', '151.65', '145.27', '-637937.00', '-140325.48', '61750.00', '15500.00'),
(45020, 5, 2022, 277, 'TAČR BETA - Energetické komunity - Vácha', 897, '1. rok 2022 (od 02/2022)', '2022-02-01', '2022-12-31', '897151.00', '0.00', '440534.00', '0.00', '49.10', '0.00', '440534.00', '0.00', '49.10', '0.00', '456617.00', '0.00', '0.00', '0.00'),
(45021, 5, 2022, 253, 'TAČR DOPRAVA - FICOS', 800, '1. rok (2022)', '2022-01-01', '2022-12-31', '1239300.00', '860000.00', '561883.00', '404142.37', '45.34', '46.99', '561883.00', '397588.71', '45.34', '46.23', '677417.00', '462411.29', '0.00', '0.00');
INSERT INTO `granty_temp` (`id`, `RP`, `rok`, `id_grantu`, `nazev_grantu`, `id_etapy`, `etapa_nazev`, `od`, `do`, `rozpocet_mzdove`, `rozpocet_ostatni`, `cerpani_soucasne_mzdove`, `cerpani_soucasne_ostatni`, `cerpani_soucasne_mzdove_procent`, `cerpani_soucasne_ostatni_procent`, `cerpani_predikce_mzdove`, `cerpani_predikce_ostatni`, `cerpani_predikce_mzdove_procent`, `cerpani_predikce_ostatni_procent`, `zbyde_mzdove`, `zbyde_ostatni`, `kofinancovani_mezd`, `kofinancovani_ostatni`) VALUES
(45022, 5, 2022, 138, 'TAČR DOPRAVA - SOMKo', 413, '2. rok (2022)', '2022-01-01', '2022-12-31', '1000155.00', '98000.00', '656617.00', '3476.00', '65.65', '3.55', '656617.00', '3419.63', '65.65', '3.49', '343538.00', '94580.37', '65661.70', '30306.96'),
(45023, 5, 2022, 230, 'TAČR ENERDIGIT DORES', 777, '1. rok (2022)', '2022-03-01', '2022-12-31', '1163025.00', '439365.00', '262750.00', '55456.00', '22.59', '12.62', '262750.00', '54386.11', '22.59', '12.38', '900275.00', '384978.89', '52550.00', '90996.62'),
(45024, 5, 2022, 161, 'TAČR ETA V - Obce mluví o vodě', 492, '2. rok (2022)', '2022-01-01', '2022-12-31', '243000.00', '0.00', '64915.00', '399.00', '26.71', '0.00', '64915.00', '392.53', '26.71', '0.00', '178085.00', '-392.53', '12983.00', '12207.00'),
(45025, 5, 2022, 75, 'TAČR THÉTA II Energetická odezva budov - ELPRAMO', 183, '4. etapa (do 12/2022) - poslední', '2022-01-01', '2022-12-31', '493645.93', '123802.84', '493617.00', '124530.44', '99.99', '100.59', '493617.00', '122511.03', '99.99', '98.96', '28.93', '1291.81', '49361.70', '12251.10'),
(45026, 5, 2022, 246, 'TAČR THETA IV - Power2Heat', 774, '1. rok (2022)', '2022-01-01', '2022-12-31', '648000.00', '0.00', '85155.00', '0.00', '13.14', '0.00', '85155.00', '0.00', '13.14', '0.00', '562845.00', '0.00', '0.00', '0.00'),
(45027, 5, 2022, 19, 'TAČR THETA NextGenDistrict', 255, '5. rok - 2022 - poslední', '2022-01-01', '2022-08-31', '645840.00', '70000.00', '535636.00', '180204.00', '82.94', '257.43', '535636.00', '117842.86', '82.94', '168.35', '110204.00', '-47842.86', '53563.60', '7000.00'),
(45028, 5, 2022, 12, 'TAČR THETA Větrací jednotka (Korado)', 226, '5. rok (2022) - poslední', '2022-01-01', '2022-06-30', '499729.32', '148727.62', '494342.00', '124011.08', '98.92', '83.38', '494342.00', '60315.75', '98.92', '40.55', '5387.32', '88411.87', '90217.42', '26803.09'),
(45029, 5, 2022, 122, 'TAČR TREND II - FullSpectraSun (Spectrasol)', 359, '3. rok (2022)', '2022-01-01', '2022-12-31', '80542.00', '0.00', '103050.00', '0.00', '127.95', '0.00', '103050.00', '0.00', '127.95', '0.00', '-22508.00', '0.00', '8054.20', '1855.50'),
(45030, 5, 2022, 143, 'TAČR TREND III - Timber Guard - Inosens', 433, '2. rok (2022)', '2022-01-01', '2022-12-31', '750439.00', '55000.00', '786190.00', '32550.88', '104.76', '59.18', '786190.00', '32023.03', '104.76', '58.22', '-35751.00', '22976.97', '187609.75', '37224.51'),
(45031, 5, 2022, 93, 'TAČR ZETA IV - WH-CarBatt', 258, '3. rok - 2022 (do 06 - poslední etapa)', '2022-01-01', '2022-06-30', '0.00', '0.00', '49590.00', '0.00', '0.00', '0.00', '49590.00', '0.00', '0.00', '0.00', '-49590.00', '0.00', '0.00', '0.00'),
(45032, 6, 2022, 275, 'MetaMorph - TAČR KAPPA - InoCure', 892, '1.etapa - 2022', '2022-01-01', '2022-12-31', '2240000.00', '2133333.00', '1664409.00', '760768.56', '74.30', '35.66', '1664409.00', '748431.77', '74.30', '35.08', '575591.00', '1384901.23', '332881.80', '368352.95'),
(45033, 6, 2022, 248, 'MVČR SECTECH NANOPACH', 783, '1. rok (2022)', '2022-01-01', '2022-12-31', '433300.00', '39000.00', '431904.00', '16655.57', '99.68', '42.71', '431904.00', '16385.48', '99.68', '42.01', '1396.00', '22614.52', '0.00', '0.00'),
(45034, 6, 2022, 203, 'Mzdový Fond RP6', 858, 'Mzdový fond RP6 rok 2022', '2022-01-01', '2022-12-31', '0.00', '0.00', '20213.00', '0.00', '0.00', '0.00', '20213.00', '0.00', '0.00', '0.00', '-20213.00', '0.00', '0.00', '0.00'),
(45035, 6, 2022, 273, 'NextPhage - TAČR TREND III - InoCure', 887, '2. Etapa (2022)', '2022-01-01', '2022-12-31', '583333.00', '540001.00', '724983.00', '291581.02', '124.28', '54.00', '724983.00', '286852.68', '124.28', '53.12', '-141650.00', '253148.32', '58333.30', '50101.97'),
(45036, 6, 2022, 91, 'TAČR ETA III - VVTO - Odorologie ', 231, '3. rok - 2022', '2022-01-01', '2022-12-31', '1055114.00', '502483.04', '1063056.00', '493796.27', '100.75', '98.27', '1063056.00', '485788.76', '100.75', '96.68', '-7942.00', '16694.28', '211022.80', '97157.75'),
(45037, 0, 2022, 301, 'Asistenční voucher (pro Interreg CE: Clear in cities)', 970, 'Realizace 1.1.-23.2.2022', '2022-01-01', '2022-04-30', '428712.06', '0.00', '237393.00', '0.00', '55.37', '0.00', '237393.00', '0.00', '55.37', '0.00', '191319.06', '0.00', '23739.30', '2044.48'),
(45038, 0, 2022, 105, 'H2020 - PLURAL', 302, 'Etapa 1c (01-03/2022)', '2022-01-01', '2022-03-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '10212.00', '0.00', '0.00', '0.00', '-10212.00', '0.00', '0.00', '0.00'),
(45039, 0, 2022, 105, 'H2020 - PLURAL', 303, 'Etapa 2a', '2022-04-01', '2022-12-31', '0.00', '0.00', '0.00', '51358.00', '0.00', '0.00', '37381.00', '50257.64', '0.00', '0.00', '-37381.00', '-50257.64', '0.00', '0.00'),
(45040, 0, 2022, 81, 'H2020 - SPARCS', 237, '2c Etapa (01/2022-03/2022)', '2022-01-01', '2022-03-31', '137653.00', '362652.06', '137653.00', '417.00', '100.00', '0.11', '137653.00', '100.26', '100.00', '0.03', '0.00', '362551.80', '0.00', '0.00'),
(45041, 0, 2022, 81, 'H2020 - SPARCS', 238, '3a etapa (04/2022-12/2022', '2022-04-01', '2022-12-31', '928461.07', '535229.76', '392720.00', '83768.77', '42.30', '15.65', '392720.00', '81973.99', '42.30', '15.32', '535741.07', '453255.77', '0.00', '0.00'),
(45042, 0, 2022, 67, 'INTERREG - Finerpol', 805, 'Prodloužení 10/2021-9/2022', '2021-10-01', '2022-10-31', '937500.00', '585000.00', '936324.00', '315833.94', '99.87', '53.99', '936324.00', '270035.31', '99.87', '46.16', '1176.00', '314964.69', '140448.60', '40505.30'),
(45043, 0, 2022, 355, 'Interreg Europe LC Districts - Lump Sum Phase 2', 1132, 'Udžovací fáze', '2022-02-01', '2023-01-31', '0.00', '184775.00', '0.00', '96792.29', '0.00', '52.38', '0.00', '95079.15', '0.00', '51.46', '0.00', '89695.85', '0.00', '18420.62'),
(45044, 0, 2022, 72, 'Interreg LC-districts', 204, '5. semestr', '2021-08-01', '2022-01-31', '545032.13', '84648.25', '560820.00', '51373.98', '102.90', '60.69', '560820.00', '17978.64', '102.90', '21.24', '-15787.88', '66669.61', '81754.82', '2696.80'),
(45045, 0, 2022, 85, 'Interreg RESINDUSTRY', 290, 'S5b (pouze 01/2022) - prázdné', '2022-01-01', '2022-01-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '55025.00', '0.00', '0.00', '0.00', '-55025.00', '0.00', '0.00', '0.00'),
(45046, 0, 2022, 85, 'Interreg RESINDUSTRY', 210, 'S6 (02/2022-07/2022)', '2022-02-01', '2022-07-31', '109046.00', '1005441.50', '355578.00', '446621.90', '326.08', '44.42', '355578.00', '237089.48', '326.08', '23.58', '-246532.00', '768352.02', '16356.90', '38997.05'),
(45047, 0, 2022, 357, 'Interreg RESINDUSTRY - Lump Sum phase 2', 1137, 'Udržovací fáze', '2022-08-01', '2023-07-31', '0.00', '1500257.70', '0.00', '95261.74', '0.00', '6.35', '0.00', '91645.16', '0.00', '6.11', '0.00', '1408612.54', '0.00', '37376.22'),
(45048, 0, 2022, 310, 'METEOPRESS Kordík OP PIK IX', 988, 'Etapa 1b (01 - 06/2022)', '2022-01-01', '2022-06-30', '40140.00', '0.00', '40140.00', '0.00', '100.00', '0.00', '40140.00', '0.00', '100.00', '0.00', '0.00', '0.00', '6021.00', '21830.36'),
(45049, 0, 2022, 310, 'METEOPRESS Kordík OP PIK IX', 989, 'Etapa 2a (07 - 12/2022)', '2022-07-01', '2022-12-31', '2458962.73', '0.00', '723218.26', '0.00', '29.41', '0.00', '723218.26', '0.00', '29.41', '0.00', '1735744.47', '0.00', '229594.48', '19845.78'),
(45050, 0, 2022, 74, 'MŠMT Inter-Inform EEB-CZ', 136, '4. etapa (do 05/2022) - poslední', '2022-01-01', '2022-05-31', '873727.00', '218275.73', '873727.00', '218275.73', '100.00', '100.00', '873727.00', '88465.58', '100.00', '40.53', '0.00', '129810.15', '0.00', '0.00'),
(45051, 0, 2022, 51, 'NCK - CAMEB M+D', 533, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '776272.00', '91474.96', '776716.00', '92516.26', '100.06', '101.14', '776716.00', '91016.00', '100.06', '99.50', '-444.00', '458.96', '0.00', '0.00'),
(45052, 0, 2022, 77, 'NCK - STD4.0', 521, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(45053, 0, 2022, 279, 'NEB-STAR HE - Kuzmič', 904, '1.rok - 2022', '2022-10-01', '2022-12-31', '91675.00', '29175.00', '25939.00', '28037.00', '28.29', '96.10', '25939.00', '26303.50', '28.29', '90.16', '65736.00', '2871.50', '0.00', '0.00'),
(45054, 0, 2022, 266, 'OP PIK Alimex', 854, 'Etapa 1 (01/2021 - 08/2022)', '2022-01-01', '2022-08-31', '3770334.12', '376470.59', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '3770334.12', '376470.59', '0.00', '84831.53'),
(45055, 0, 2022, 266, 'OP PIK Alimex', 1027, 'Etapa 2a (09 - 12/2022)', '2022-09-01', '2022-12-31', '1885167.06', '188235.29', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '1885167.06', '188235.29', '0.00', '42415.76'),
(45056, 0, 2022, 263, 'OP PIK Alpha Analytics FIT', 842, 'etapa 1b (01 - 06/2022)', '2022-01-01', '2022-06-30', '362134.00', '0.00', '362134.00', '0.00', '100.00', '0.00', '362134.00', '0.00', '100.00', '0.00', '0.00', '0.00', '98031.23', '17304.30'),
(45057, 0, 2022, 263, 'OP PIK Alpha Analytics FIT', 843, 'etapa 2a (07 - 12/2022)', '2022-07-01', '2022-12-31', '2714195.18', '0.00', '406547.80', '0.00', '14.98', '0.00', '406547.80', '0.00', '14.98', '0.00', '2307647.38', '0.00', '220260.37', '17304.30'),
(45058, 0, 2022, 151, 'OP PIK Amcon', 464, 'E2 b', '2022-01-01', '2022-01-31', '76372.69', '0.00', '76372.69', '0.00', '100.00', '0.00', '76372.69', '0.00', '100.00', '0.00', '0.00', '0.00', '11455.90', '1665.01'),
(45059, 0, 2022, 151, 'OP PIK Amcon', 465, 'E3', '2022-02-01', '2022-12-31', '1067809.00', '274835.79', '1067731.13', '274837.00', '99.99', '100.00', '1067731.13', '269972.63', '99.99', '98.23', '77.87', '4863.16', '242410.54', '58810.96'),
(45060, 0, 2022, 282, 'OP PIK IX CEBIA AUTOTRACER FIT', 901, 'Etapa 1b (01 - 06/2022)', '2022-01-01', '2022-06-30', '1207288.00', '0.00', '1207288.00', '0.00', '100.00', '0.00', '1207288.00', '0.00', '100.00', '0.00', '0.00', '0.00', '215327.27', '36089.84'),
(45061, 0, 2022, 282, 'OP PIK IX CEBIA AUTOTRACER FIT', 902, 'Etapa 2a (07 - 12/2022)', '2022-07-01', '2022-12-31', '3337362.18', '0.00', '1234877.76', '0.00', '37.00', '0.00', '1234877.76', '0.00', '37.00', '0.00', '2102484.42', '0.00', '435695.90', '36089.84'),
(45062, 0, 2022, 289, 'OP PIK IX CEBIA DIGITALIZACE VIN FIT', 937, 'E1 b (01 - 06/2022)', '2022-01-01', '2022-06-30', '984754.00', '0.00', '984754.00', '0.00', '100.00', '0.00', '984754.00', '0.00', '100.00', '0.00', '0.00', '0.00', '151385.91', '30345.79'),
(45063, 0, 2022, 289, 'OP PIK IX CEBIA DIGITALIZACE VIN FIT', 938, 'E2 a (07 - 12/2022)', '2022-07-01', '2022-12-31', '2836574.00', '0.00', '1498808.52', '0.00', '52.84', '0.00', '1498808.52', '0.00', '52.84', '0.00', '1337765.48', '0.00', '297403.76', '30345.79'),
(45064, 0, 2022, 84, 'OP PIK MAWISPhoto', 250, 'Etapa 3b POSLEDNÍ (01/22-09/22)', '2022-01-01', '2022-09-30', '405808.17', '0.00', '258884.18', '0.00', '63.79', '0.00', '258884.18', '0.00', '63.79', '0.00', '146923.99', '0.00', '122952.15', '12117.19'),
(45065, 0, 2022, 190, 'OP PIK MOB-Bars FSv', 618, 'etapa 2b (01 - 08/2022)', '2022-01-01', '2022-08-31', '569315.54', '133100.00', '569315.54', '133100.00', '100.00', '100.00', '569315.54', '87039.61', '100.00', '65.39', '0.00', '46060.39', '163543.22', '13055.94'),
(45066, 0, 2022, 190, 'OP PIK MOB-Bars FSv', 619, 'etapa 3a (09 - 12/2022)', '2022-09-01', '2022-12-31', '599972.00', '69186.56', '300199.36', '49622.10', '50.04', '71.72', '300199.36', '47278.52', '50.04', '68.33', '299772.64', '21908.04', '67766.54', '7091.78'),
(45067, 0, 2022, 261, 'OP PIK TEAS_DMS FIT', 832, 'etapa 2b (01 - 06/2022)', '2022-01-01', '2022-06-30', '906271.63', '0.00', '906271.63', '0.00', '100.00', '0.00', '906271.63', '0.00', '100.00', '0.00', '0.00', '0.00', '160137.13', '19652.47'),
(45068, 0, 2022, 261, 'OP PIK TEAS_DMS FIT', 833, 'etapa 3a (07 - 12/2022)', '2022-07-01', '2022-12-31', '2082386.18', '0.00', '712726.87', '0.00', '34.23', '0.00', '712726.87', '0.00', '34.23', '0.00', '1369659.31', '0.00', '207679.16', '19652.46'),
(45069, 0, 2022, 262, 'OP PIK TEAS_Servis FIT', 837, 'etapa 2b (01 - 06/2022)', '2022-01-01', '2022-06-30', '1434246.59', '0.00', '1434246.59', '0.00', '100.00', '0.00', '1434246.59', '0.00', '100.00', '0.00', '0.00', '0.00', '273357.38', '17737.80'),
(45070, 0, 2022, 262, 'OP PIK TEAS_Servis FIT', 838, 'etapa 3a (07 - 12/2022)', '2022-07-01', '2022-12-31', '471727.82', '0.00', '897543.38', '0.00', '190.27', '0.00', '897543.38', '0.00', '190.27', '0.00', '-425815.56', '0.00', '266093.79', '17737.79'),
(45071, 0, 2022, 219, 'OP PIK VYRTYCH - FEL', 804, 'Etapa 1c (01 - 07/2022)', '2022-01-01', '2022-07-31', '1868703.93', '170828.12', '1826595.94', '170828.09', '97.75', '100.00', '1826595.94', '97398.94', '97.75', '57.02', '42107.99', '73429.18', '90333.74', '0.00'),
(45072, 0, 2022, 47, 'OP VVV - CAP', 246, '2022 (prodlouženo do 04.2023)', '2022-01-01', '2022-12-31', '257000.00', '0.00', '296493.00', '0.00', '115.37', '0.00', '296493.00', '0.00', '115.37', '0.00', '-39493.00', '0.00', '12850.00', '0.00'),
(45073, 0, 2022, 49, 'OP VVV - HRAWARD', 195, '5. rok - 2022 - poslední', '2022-01-01', '2022-12-31', '469274.00', '1036356.25', '468705.00', '604395.35', '99.88', '58.32', '468705.00', '594594.34', '99.88', '57.37', '569.00', '441761.91', '23435.25', '29729.72'),
(45074, 0, 2022, 169, 'Režie - finanční oddělení', 513, 'Rok 2022', '2022-01-01', '2022-12-31', '0.00', '0.00', '0.00', '192780.61', '0.00', '0.00', '0.00', '189654.44', '0.00', '0.00', '0.00', '-189654.44', '0.00', '0.00'),
(45075, 0, 2022, 170, 'Režie - marketing', 516, 'Rok 2022', '2022-01-01', '2022-12-31', '0.00', '0.00', '1204.00', '233801.32', '0.00', '0.00', '1204.00', '230009.95', '0.00', '0.00', '-1204.00', '-230009.95', '0.00', '0.00'),
(45076, 0, 2022, 98, 'Režie - ostatní', 867, 'rok 2022', '2022-01-01', '2022-12-31', '0.00', '0.00', '6814307.00', '0.00', '0.00', '0.00', '6814307.00', '0.00', '0.00', '0.00', '-6814307.00', '0.00', '0.00', '0.00'),
(45077, 0, 2022, 168, 'Režie - projektové oddělení', 510, 'Rok 2022', '2022-01-01', '2022-12-31', '0.00', '0.00', '0.00', '41374.26', '0.00', '0.00', '0.00', '40703.33', '0.00', '0.00', '0.00', '-40703.33', '0.00', '0.00'),
(45078, 0, 2022, 167, 'Režie - ředitel', 507, 'Rok 2022', '2022-01-01', '2022-12-31', '0.00', '0.00', '2247.00', '440879.44', '0.00', '0.00', '2247.00', '433730.04', '0.00', '0.00', '-2247.00', '-433730.04', '0.00', '0.00'),
(45079, 0, 2022, 94, 'Režie - správa budovy', 868, '3. etapa 2022', '2022-01-01', '2022-12-31', '0.00', '0.00', '3530671.00', '0.00', '0.00', '0.00', '3530671.00', '0.00', '0.00', '0.00', '-3530671.00', '0.00', '0.00', '0.00'),
(45080, 0, 2022, 306, 'UNICO Kordík OP PIK IX', 991, 'Etapa 1b (01 - 05/2022)', '2022-01-01', '2022-05-31', '652676.50', '0.00', '223227.22', '0.00', '34.20', '0.00', '223227.22', '0.00', '34.20', '0.00', '429449.28', '0.00', '34567.86', '8158.43'),
(45081, 0, 2022, 306, 'UNICO Kordík OP PIK IX', 975, 'Etapa 2a (06-12/2022)', '2022-06-01', '2022-12-31', '507637.38', '0.00', '1021014.56', '0.00', '201.13', '0.00', '1021014.56', '0.00', '201.13', '0.00', '-513377.18', '0.00', '106949.05', '11421.80'),
(45082, 0, 2022, 335, 'Y Soft Kordík OP PIK ', 1068, 'Etapa 2a (03-12/2022)', '2022-03-01', '2022-12-31', '2585016.00', '0.00', '1211269.09', '0.00', '46.86', '0.00', '1211269.09', '0.00', '46.86', '0.00', '1373746.91', '0.00', '412087.27', '0.00'),
(45083, 1, 2022, 288, 'Cir4ConClimate EUKI - Pavlů', 969, '1.rok - 2022', '2022-12-01', '2022-12-31', '176525.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '176525.00', '0.00', '0.00', '1735.50'),
(45084, 1, 2022, 272, 'CRAFT HE - Vácha', 882, 'rok 2022', '2022-05-01', '2022-12-31', '0.00', '0.00', '100664.00', '0.00', '0.00', '0.00', '100664.00', '0.00', '0.00', '0.00', '-100664.00', '0.00', '0.00', '0.00'),
(45085, 1, 2022, 89, 'GAČR - Plíseň', 213, '3. rok - 2022 - poslední', '2022-01-01', '2022-12-31', '502200.00', '110000.00', '505662.00', '106665.06', '100.69', '96.97', '505662.00', '104935.36', '100.69', '95.40', '-3462.00', '5064.64', '0.00', '0.00'),
(45086, 1, 2022, 226, 'GAČR LA - TRC Slovinsko - Hájek', 711, '1. rok (2022)', '2022-03-01', '2022-12-31', '1322000.00', '188000.00', '1218401.00', '191681.12', '92.16', '101.96', '1218401.00', '187983.09', '92.16', '99.99', '103599.00', '16.91', '0.00', '0.00'),
(45087, 1, 2022, 210, 'H2020 - ARV', 662, 'etapa 1a - rok 2022', '2022-01-01', '2022-12-31', '768993.75', '0.00', '789007.00', '85688.48', '102.60', '0.00', '789007.00', '84298.94', '102.60', '0.00', '-20013.25', '-84298.94', '0.00', '0.00'),
(45088, 1, 2022, 105, 'H2020 - PLURAL', 302, 'Etapa 1c (01-03/2022)', '2022-01-01', '2022-03-31', '5322.00', '0.00', '5322.00', '0.00', '100.00', '0.00', '5322.00', '0.00', '100.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(45089, 1, 2022, 80, 'H2020 - POWERSKIN PLUS', 242, '2b (1/22-9/22)', '2022-01-01', '2022-09-30', '1031187.00', '932968.28', '1031187.00', '18879.45', '100.00', '2.02', '1031187.00', '13876.82', '100.00', '1.49', '0.00', '919091.45', '0.00', '0.00'),
(45090, 1, 2022, 80, 'H2020 - POWERSKIN PLUS', 243, '3a (10/22-12/22)', '2022-10-01', '2022-12-31', '362594.82', '1169740.83', '15071.00', '0.00', '4.16', '0.00', '15071.00', '0.00', '4.16', '0.00', '347523.82', '1169740.83', '0.00', '0.00'),
(45091, 1, 2022, 81, 'H2020 - SPARCS', 237, '2c Etapa (01/2022-03/2022)', '2022-01-01', '2022-03-31', '2370.00', '0.00', '2370.00', '0.00', '100.00', '0.00', '2370.00', '0.00', '100.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(45092, 1, 2022, 81, 'H2020 - SPARCS', 238, '3a etapa (04/2022-12/2022', '2022-04-01', '2022-12-31', '63498.99', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '63498.99', '0.00', '0.00', '0.00'),
(45093, 1, 2022, 72, 'Interreg LC-districts', 204, '5. semestr', '2021-08-01', '2022-01-31', '16056.00', '0.00', '18372.00', '0.00', '114.42', '0.00', '18372.00', '0.00', '114.42', '0.00', '-2316.00', '0.00', '2408.40', '0.00'),
(45094, 1, 2022, 356, 'Kampus Dejvice PPRS 2022 - Vlasatá', 1136, '1.etapa - 2022 (jednoletka)', '2022-10-01', '2022-12-31', '150000.00', '0.00', '150000.00', '0.00', '100.00', '0.00', '150000.00', '0.00', '100.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(45095, 1, 2022, 321, 'MERIT COFUND HE - Tywoniak', 1025, '1. rok - 2022', '2022-08-01', '2027-12-31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(45096, 1, 2022, 291, 'MOBILITY OP VVV - Řepka', 947, 'Rok 2022', '2022-04-01', '2022-10-31', '426246.60', '0.00', '375600.00', '0.00', '88.12', '0.00', '375600.00', '0.00', '88.12', '0.00', '50646.60', '0.00', '18780.00', '4814.69'),
(45097, 1, 2022, 87, 'MŠMT INTER ACTION INDIE', 200, '3. rok - 2022 poslední', '2022-01-01', '2022-12-31', '1951035.00', '481133.54', '1885653.00', '255569.13', '96.65', '53.12', '1885653.00', '251424.77', '96.65', '52.26', '65382.00', '229708.77', '0.00', '0.00'),
(45098, 1, 2022, 53, 'MŠMT INTER TRANSFER Annex 72 - životní cyklus budov', 519, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '120000.00', '292682.82', '196423.00', '174475.84', '163.69', '59.61', '196423.00', '171646.50', '163.69', '58.65', '-76423.00', '121036.32', '0.00', '0.00'),
(45099, 1, 2022, 2, 'MVČR - BV Hejtmánek', 518, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '848346.60', '40820.44', '785869.75', '32159.30', '92.64', '78.78', '785869.75', '31637.80', '92.64', '77.50', '62476.85', '9182.64', '0.00', '0.00'),
(45100, 1, 2022, 201, 'Mzdový Fond RP1', 848, '2022', '2022-01-01', '2022-12-31', '0.00', '0.00', '785851.00', '0.00', '0.00', '0.00', '785851.00', '0.00', '0.00', '0.00', '-785851.00', '0.00', '0.00', '0.00'),
(45101, 1, 2022, 63, 'NCK - BIMIP', 525, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '693900.05', '222819.21', '708823.00', '216907.72', '102.15', '97.35', '708823.00', '213390.30', '102.15', '95.77', '-14922.95', '9428.91', '0.00', '0.00'),
(45102, 1, 2022, 65, 'NCK - MTS', 527, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '323775.00', '165540.02', '328251.00', '161066.31', '101.38', '97.30', '328251.00', '158454.42', '101.38', '95.72', '-4476.00', '7085.60', '0.00', '0.00'),
(45103, 1, 2022, 62, 'NCK - RESOPT', 529, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '0.00', '0.00', '5005.00', '0.00', '0.00', '0.00', '5005.00', '0.00', '0.00', '0.00', '-5005.00', '0.00', '0.00', '0.00'),
(45104, 1, 2022, 77, 'NCK - STD4.0', 521, '4. rok (do 12/2022 - poslední)', '2022-01-01', '2022-12-31', '80000.00', '0.00', '83244.00', '5062.64', '104.06', '0.00', '83244.00', '4980.54', '104.06', '0.00', '-3244.00', '-4980.54', '0.00', '0.00'),
(45105, 1, 2022, 174, 'OP PIK LASSO', 553, 'etapa 2b (01 - 07/2022)', '2022-01-01', '2022-07-31', '958747.17', '26167.46', '958747.17', '26167.46', '100.00', '100.00', '958747.17', '14919.58', '100.00', '57.02', '0.00', '11247.88', '176848.64', '22952.27'),
(45106, 1, 2022, 174, 'OP PIK LASSO', 554, 'etapa 3a (08 - 12/2022)', '2022-08-01', '2022-12-31', '1210116.00', '960902.79', '893575.13', '0.00', '73.84', '0.00', '893575.13', '0.00', '73.84', '0.00', '316540.87', '960902.79', '164774.14', '14795.97'),
(45107, 1, 2022, 176, 'OP PIK ReTechSDOZero', 563, 'etapa 2b (01 - 8/2022)', '2022-01-01', '2022-08-31', '1194384.62', '0.00', '1194384.62', '0.00', '100.00', '0.00', '1194384.62', '0.00', '100.00', '0.00', '0.00', '0.00', '240799.35', '30512.80'),
(45108, 1, 2022, 176, 'OP PIK ReTechSDOZero', 564, 'etapa 3a (09 - 12/2022)', '2022-09-01', '2022-12-31', '1576325.04', '148888.89', '697046.14', '35749.84', '44.22', '24.01', '697046.14', '34061.43', '44.22', '22.88', '879278.90', '114827.46', '113213.78', '20365.61'),
(45109, 1, 2022, 200, 'OP PIK ZdrOk / VEKRA', 632, 'etapa 2b (01 - 07/2022)', '2022-01-01', '2022-07-31', '1296998.00', '0.00', '1296998.00', '292595.11', '100.00', '0.00', '1296998.00', '166825.34', '100.00', '0.00', '0.00', '-166825.34', '286044.81', '42569.83'),
(45110, 1, 2022, 200, 'OP PIK ZdrOk / VEKRA', 633, 'etapa 3a (08-12/2022)', '2022-08-01', '2022-12-31', '2071852.40', '0.00', '1157376.05', '381718.69', '55.86', '0.00', '1157376.05', '367226.87', '55.86', '0.00', '914476.35', '-367226.87', '232656.36', '30407.13'),
(45111, 1, 2022, 47, 'OP VVV - CAP', 246, '2022 (prodlouženo do 04.2023)', '2022-01-01', '2022-12-31', '480000.00', '0.00', '412876.00', '7617.10', '86.02', '0.00', '412876.00', '7493.58', '86.02', '0.00', '67124.00', '-7493.58', '20643.80', '0.00'),
(45112, 1, 2022, 346, 'Probono H2020 - Tencar', 1101, '1.rok - 2022', '2022-01-01', '2022-12-31', '111218.25', '2844.27', '100093.00', '13970.00', '90.00', '491.16', '100093.00', '13743.46', '90.00', '483.20', '11125.25', '-10899.19', '0.00', '0.00'),
(45113, 1, 2022, 307, 'SVK (MŠMT) 56/22/F6 Sojková', 977, 'rok 2022 (poslední)', '2022-05-01', '2022-12-31', '47000.00', '112500.00', '53400.00', '106100.00', '113.62', '94.31', '53400.00', '103554.02', '113.62', '92.05', '-6400.00', '8945.98', '0.00', '0.00'),
(45114, 1, 2022, 317, 'Šance pro budovy ECF - Vlasatá', 1013, '2022 (jednoletka)', '2022-05-01', '2022-12-31', '675000.00', '132500.00', '643261.00', '5170.00', '95.30', '3.90', '643261.00', '5045.94', '95.30', '3.81', '31739.00', '127454.06', '0.00', '0.00'),
(45115, 1, 2022, 138, 'TAČR DOPRAVA - SOMKo', 413, '2. rok (2022)', '2022-01-01', '2022-12-31', '155000.00', '0.00', '65359.00', '0.00', '42.17', '0.00', '65359.00', '0.00', '42.17', '0.00', '89641.00', '0.00', '6535.90', '0.00'),
(45116, 1, 2022, 161, 'TAČR ETA V - Obce mluví o vodě', 492, '2. rok (2022)', '2022-01-01', '2022-12-31', '220000.00', '6500.00', '156547.00', '1950.00', '71.16', '30.00', '156547.00', '1918.38', '71.16', '29.51', '63453.00', '4581.62', '31309.40', '11651.68'),
(45117, 1, 2022, 128, 'TAČR PPŽ - DECOMPOSE', 384, '2. rok (2022)', '2022-01-01', '2022-12-31', '340000.00', '28000.00', '283525.00', '18505.00', '83.39', '66.09', '283525.00', '18204.92', '83.39', '65.02', '56475.00', '9795.08', '0.00', '0.00'),
(45118, 1, 2022, 284, 'TAČR TREND - REWAGYPS (Staněk)', 927, 'rok 2022', '2022-01-01', '2022-12-31', '247492.80', '45000.00', '250283.00', '44129.58', '101.13', '98.07', '250283.00', '43413.97', '101.13', '96.48', '-2790.20', '1586.03', '0.00', '0.00'),
(45119, 1, 2022, 122, 'TAČR TREND II - FullSpectraSun (Spectrasol)', 359, '3. rok (2022)', '2022-01-01', '2022-12-31', '31949.00', '0.00', '1160.00', '0.00', '3.63', '0.00', '1160.00', '0.00', '3.63', '0.00', '30789.00', '0.00', '116.00', '927.75'),
(45120, 1, 2022, 121, 'TAČR TREND III - Automation4Timber', 354, '2. rok (2022)', '2022-01-01', '2022-12-31', '2387100.00', '271062.27', '2385054.00', '115834.70', '99.91', '42.73', '2385054.00', '113956.30', '99.91', '42.04', '2046.00', '157105.97', '319835.74', '102785.14'),
(45121, 1, 2022, 143, 'TAČR TREND III - Timber Guard - Inosens', 433, '2. rok (2022)', '2022-01-01', '2022-12-31', '130000.00', '0.00', '147962.00', '0.00', '113.82', '0.00', '147962.00', '0.00', '113.82', '0.00', '-17962.00', '0.00', '32500.00', '29218.75'),
(45122, 1, 2022, 228, 'TAČR TREND IV -  PReRaSyD ecokit', 720, '1. rok (2022)', '2022-01-01', '2022-12-31', '644800.00', '0.00', '633441.00', '1030.00', '98.24', '0.00', '633441.00', '1013.30', '98.24', '0.00', '11359.00', '-1013.30', '63344.10', '0.00'),
(45123, 1, 2022, 104, 'TAČR ZETA IV - MOBRECLIN recyklační linka', 299, '3.rok (do 07/2022 - poslední)', '2022-01-01', '2022-07-31', '154303.00', '6002.00', '160219.00', '86.00', '103.83', '1.43', '160219.00', '49.03', '103.83', '0.82', '-5916.00', '5952.97', '0.00', '0.00'),
(45124, 1, 2022, 286, 'UNILEAD MŠMT - CRP 2022', 940, '2022 (jednoletka)', '2022-01-01', '2022-12-31', '350000.00', '70000.00', '350152.00', '69826.00', '100.04', '99.75', '350152.00', '68693.69', '100.04', '98.13', '-152.00', '1306.31', '0.00', '0.00'),
(45125, 1, 2022, 333, 'Vícevrstvy GAČR - FSv Sněhota', 1063, '1.rok - 2022', '2022-04-01', '2022-12-31', '419000.00', '27000.00', '286833.00', '24109.38', '68.46', '89.29', '286833.00', '23592.83', '68.46', '87.38', '132167.00', '3407.17', '0.00', '0.00');

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

--
-- Struktura tabulky `jine_naklady`
--

CREATE TABLE `jine_naklady` (
  `id` int(11) NOT NULL,
  `skupinaRP` int(11) NOT NULL DEFAULT -1 COMMENT 'číslo skupiny RP',
  `predmet` varchar(255) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT 'co bude nakladem',
  `cena` int(11) NOT NULL DEFAULT 0,
  `datum` date DEFAULT NULL COMMENT 'termín uskutečnění nákladu',
  `editoval_kdo` varchar(31) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `editoval_kdy` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Obsahuje data ze stránky Ekonomické plánování/Jiné náklady';

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

--
-- Struktura tabulky `kpi_impaktovane_publikace`
--

CREATE TABLE `kpi_impaktovane_publikace` (
  `id` int(11) NOT NULL,
  `rok` int(11) DEFAULT NULL COMMENT 'rok ke kterému se nastavená hodnota vztahuje',
  `RP` int(11) DEFAULT NULL COMMENT 'skupina RP ke které se nastavená hodnota vztahuje',
  `nastaveno` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT 'správcem aplikace nastavená hodnota',
  `splnene_kpi` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT 'správcem aplikace nastavená hodnota ',
  `editovano_kym` varchar(31) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT 'login osoby, která naposledy měnila pole ''nasatveno'' nebo ''splnene_kpi'''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Data z buněk KPI impaktované publikace na stránce Report';

--
-- Vypisuji data pro tabulku `kpi_impaktovane_publikace`
--

INSERT INTO `kpi_impaktovane_publikace` (`id`, `rok`, `RP`, `nastaveno`, `splnene_kpi`, `editovano_kym`) VALUES
(20, 2022, 3, '1.69', '1.00', 'dytrijak'),
(36, 2022, 5, '3.59', '0.75', 'dytrijak'),
(44, 2022, 4, '1.04', '1.04', 'dytrijak'),
(45, 2022, 1, '4.00', '2.13', 'dytrijak'),
(49, 2022, 6, '0.70', '1.20', 'dytrijak'),
(50, 2022, 2, '3.87', '5.90', 'dytrijak');

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

--
-- Struktura tabulky `nastaveni`
--

CREATE TABLE `nastaveni` (
  `zvyrazneny_rozdil_cerpani_predikce` int(11) NOT NULL DEFAULT 0 COMMENT 'Pokud bude hodnota na hlavni straně ve sloupci Čerpání predikce odlišná od 100 o více procent než zde nastavená hodnota, tak dojde k jejímu barevnému zvýraznění'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='nastavitelné výchozí hodnoty pro různé prvky v Ekonom.plánov';

--
-- Vypisuji data pro tabulku `nastaveni`
--

INSERT INTO `nastaveni` (`zvyrazneny_rozdil_cerpani_predikce`) VALUES
(10);

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

--
-- Struktura tabulky `opravneni_rp`
--

CREATE TABLE `opravneni_rp` (
  `login` varchar(63) COLLATE utf8_czech_ci NOT NULL,
  `RP` int(11) NOT NULL COMMENT 'číslo skupiny RP',
  `role` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=nahlížející; 1=editor 	'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='loginy uživatelů, kteří mají právo nahlížet na data dané skupiny RP';

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

--
-- Struktura tabulky `plan_obchodu`
--

CREATE TABLE `plan_obchodu` (
  `id` int(11) NOT NULL,
  `stav` int(11) NOT NULL DEFAULT 0 COMMENT '0=obchod vrácen(zrušen) druhou RP skupinou; 1=obchod vytvožen; 2=obchod schválen druhou RP skupino',
  `davaSkupinaRP` int(11) NOT NULL DEFAULT -1 COMMENT 'číslo skupiny RP',
  `dostavaSkupinaRP` int(11) NOT NULL DEFAULT -1,
  `co_dava` varchar(255) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT 'co skupina RP dává',
  `co_dostava` varchar(255) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT 'co skupina za to dostává',
  `datum` date DEFAULT NULL COMMENT 'termín uskutečnění obchodu',
  `editoval_kdo` varchar(31) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `editoval_kdy` date DEFAULT NULL,
  `schvaleno_vedoucim_RP_na_strane_dostava` varchar(63) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `schvaleno_vedoucim_RP_na_strane_dostava_kdy` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Obsahuje data ze stránky Ekonomické plánování/Plán obchodů';

--
-- Vypisuji data pro tabulku `plan_obchodu`
--

INSERT INTO `plan_obchodu` (`id`, `stav`, `davaSkupinaRP`, `dostavaSkupinaRP`, `co_dava`, `co_dostava`, `datum`, `editoval_kdo`, `editoval_kdy`, `schvaleno_vedoucim_RP_na_strane_dostava`, `schvaleno_vedoucim_RP_na_strane_dostava_kdy`) VALUES
(2, 2, 5, 3, '325 tis. Kč mzdové na TAČR Korado v roce 2021', 'Vyšší čerpání mzdových prostředků v OP PIK Korado v roce 2020', '2021-01-07', 'wawerrob', '2021-01-07', 'adamodan', '2021-01-07'),
(3, 2, 5, 3, '50 tis. Kč mzdové na TAČR Korado v roce 2021', 'Indikátory: 1 x 7M, 3 x 10 M, 1 x doktorand', '2021-01-11', 'wawerrob', '2021-01-11', 'adamodan', '2021-01-11'),
(4, 2, 5, 6, 'veškerý svůj finanční podíl ze zakázky 8302019V100 - Měření signálu přes nanovlákna + měření dalších vzorků s karbonizovanou textilií', '3 x impakt 6M', '2021-01-11', 'wawerrob', '2021-01-11', 'vanzujan', '2021-01-12'),
(5, 2, 3, 1, '70 tis. mzdových peněz z fondu účtu VO3 na účet VO1', 'monitorovací indikátor 9M - doplňuji tento obchod na základě komunikace z 18.12.', '2020-12-21', 'adamodan', '2021-01-11', 'lupisant', '2021-01-11'),
(6, 2, 3, 4, '835 tis. z indikátoru smluvní výzkum', '24 tis. Kč do ziskového fondu', '2021-01-23', 'adamodan', '2021-01-23', 'jararobe', '2021-01-25'),
(7, 2, 1, 2, '30000 Kč ze mzdového fondu', 'Je to zpětně za pomoc Jirky Novotného na zakázce CPI', '2021-01-25', 'lupisant', '2021-01-25', 'matustom', '2021-01-25'),
(8, 2, 2, 3, '1000000 Kč smluvní výzkum indikátorový', '1 doktoranda indikátorového', '2021-01-21', 'matustom', '2021-02-04', 'adamodan', '2021-02-04'),
(9, 2, 2, 5, '4x7M, 1x12M, 600 tis. Kč indikátorový SV', 'zaplacení výjezdu kluků do Dubaje z projektu a ne ze smluváku', '2021-01-21', 'matustom', '2021-02-04', 'wawerrob', '2021-02-04'),
(10, 2, 3, 4, '835 tis. Kč monitorovacího indikátoru smluvního výzkumu', '24 tis. Kč do zisku VO3', '2021-01-22', 'adamodan', '2021-02-04', 'jararobe', '2021-02-04'),
(11, 2, 5, 1, '35 tis. Kč mzdy projektové (Powerskin)', '1 x 12M – ověřená technologie, poloprovoz', '2021-02-04', 'wawerrob', '2021-02-04', 'lupisant', '2021-02-22'),
(12, 2, 3, 6, '1x indikátor 10M', 'úsměv kolegy :-)', '2021-02-04', 'adamodan', '2021-02-04', 'vanzujan', '2021-02-04'),
(13, 2, 2, 6, '7x indikátor 19M', 'nic', '2021-02-11', 'dytrijak', '2021-02-11', 'vanzujan', '2021-02-12'),
(14, 2, 6, 4, 'článek s impaktem v horním qvartilu (Q1) v roce 2022', '1x výsledek 5M', '2021-02-16', 'vanzujan', '2021-02-16', 'jararobe', '2021-02-16'),
(15, 2, 6, 1, 'spolupráce na publikaci na téma využití nanovláken ve stavebnictví', '3x výsledek 10M', '2021-02-19', 'vanzujan', '2021-02-19', 'lupisant', '2021-02-22'),
(16, 2, 1, 5, 'CAP platil Nikose minulý rok a řešili jsme barter indikátoru 1x 12 M.', 'RP5 dostane v projektu Powerskin v etapě 2a 226 600 ve mzdách. Touto operací se zároveň vyclearuje bartr s datem 2021-02-04', '2021-03-03', 'lupisant', '2021-03-03', 'wawerrob', '2021-03-03'),
(17, 2, 5, 1, 'Úvazek CAP Nikos', '167 000 ve mzdách projekt Powerskin nebo jiný v roce 2022', '2021-11-19', 'wawerrob', '2021-11-19', 'volfmar3', '2021-11-22'),
(18, 2, 5, 1, 'Nikos impakt \"An optimization approach to photovoltaic building integration towards low energy buildings in different climate zones, Applied Energy\"', 'Dělení mezi VO5 a VO1 je 80 % : 20 %', '2021-11-19', 'wawerrob', '2021-11-19', 'volfmar3', '2021-11-22'),
(19, 2, 1, 3, '8h práce J. Vítovce', '7800 Kč z mzdového fondu VO3 do mzdového fondu VO1', '2021-12-03', 'volfmar3', '2021-12-03', 'adamodan', '2022-01-06'),
(20, 2, 5, 0, 'ARV - podíl 50% režií materiálu (investic) do stavby jde za v0', 'zbylých 50 % režií materiálu (investic) do stavby jde do zisku VO5', '2022-02-03', 'wawerrob', '2022-02-03', 'dytrijak', '2022-02-07'),
(21, 2, 1, 5, '61000 Kč ze zisku VO1', 'pokrytí ztráty v CAMEB RESOPT za 2021', '2022-03-08', 'volfmar3', '2022-03-08', 'wawerrob', '2022-03-08'),
(22, 2, 1, 5, '45 000 Kč ze zisku VO1 do zisku VO5', 'pokrytí mezd z H2020 Plural', '2022-03-08', 'volfmar3', '2022-03-08', 'wawerrob', '2022-03-08'),
(23, 2, 1, 5, 'převod zůstatku projektu H2020 Plural od VO1 k VO5', '59 422.50 do rozpočtu VO5 v Pluralu', '2022-03-08', 'volfmar3', '2022-03-08', 'wawerrob', '2022-03-08'),
(24, 2, 1, 5, '21 000 Kč ze zisku VO1 do zisku VO5', 'pokrytí části mezd v H2020 SPARCS', '2022-03-08', 'volfmar3', '2022-03-08', 'wawerrob', '2022-03-08');

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

--
-- Struktura tabulky `report_dalsi_udaje`
--

CREATE TABLE `report_dalsi_udaje` (
  `RP` int(11) NOT NULL COMMENT 'číslo RP',
  `rok` int(11) NOT NULL COMMENT 'rok pro který daný řádek tab. platí',
  `ocekavane_nemzdove_rezijni_naklady` int(11) NOT NULL DEFAULT 0 COMMENT 'zadává správce aplikace (pro RP0)',
  `objem_rezijniho_DKRVO` int(11) NOT NULL DEFAULT 0 COMMENT 'zadává správce aplikace (pro RP0)',
  `predpokladana_rezie_ze_smluv_vyzkumu` int(11) NOT NULL DEFAULT 0 COMMENT 'zadává správce aplikace (pro RP0)',
  `ocekavana_dan_z_prijmu_prav_osob` int(11) NOT NULL DEFAULT 0 COMMENT 'zadává správce aplikace (pro RP0)',
  `ocekavany_podil_DKRVO` int(11) NOT NULL DEFAULT 0 COMMENT 'zadává správce aplikace (pro RP1-6)',
  `editoval_kdo` varchar(31) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `editoval_kdy` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='hodnoty zadávané na str. Report(mimo KPI,ty mají svou tab.)';

--
-- Vypisuji data pro tabulku `report_dalsi_udaje`
--

INSERT INTO `report_dalsi_udaje` (`RP`, `rok`, `ocekavane_nemzdove_rezijni_naklady`, `objem_rezijniho_DKRVO`, `predpokladana_rezie_ze_smluv_vyzkumu`, `ocekavana_dan_z_prijmu_prav_osob`, `ocekavany_podil_DKRVO`, `editoval_kdo`, `editoval_kdy`) VALUES
(0, 2022, 22241856, 2181000, 5942796, 538042, 0, 'dytrijak', '2023-01-06'),
(1, 2022, 0, 0, 0, 0, 602161, 'dytrijak', '2022-11-22'),
(2, 2022, 0, 0, 0, 0, 2591731, 'dytrijak', '2022-11-22'),
(3, 2022, 0, 0, 0, 0, 275154, 'dytrijak', '2022-11-22'),
(4, 2022, 0, 0, 0, 0, 370680, 'dytrijak', '2022-11-22'),
(5, 2022, 0, 0, 0, 0, 686854, 'dytrijak', '2022-11-22'),
(6, 2022, 0, 0, 0, 0, 403045, 'dytrijak', '2022-11-22');

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

--
-- Struktura tabulky `report_objem_rezii_vsech_rp`
--

CREATE TABLE `report_objem_rezii_vsech_rp` (
  `rok` int(11) NOT NULL COMMENT 'PK',
  `RP` int(11) NOT NULL COMMENT 'PK',
  `celkove_rezie` decimal(11,2) NOT NULL DEFAULT 0.00 COMMENT 'celkové režie pro daný rok dopočítané dle predikce mzdových nákladů a predikce ostatních nákladů',
  `celkove_rezie_dle_rozpoctu` decimal(11,2) NOT NULL DEFAULT 0.00 COMMENT 'celkové režie pro daný rok dopočítané dle predikce mzdových nákladů a plán.rozpočtu ostatních nákladů',
  `datum_vypoctu` date DEFAULT NULL COMMENT 'datum, kdy došlo k výpočtu a uložení této hodnoty'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Plní se při zobrazování 1.tabulky na hlavní straně ek.plánov';

--
-- Vypisuji data pro tabulku `report_objem_rezii_vsech_rp`
--

INSERT INTO `report_objem_rezii_vsech_rp` (`rok`, `RP`, `celkove_rezie`, `celkove_rezie_dle_rozpoctu`, `datum_vypoctu`) VALUES
(2020, 1, '3740243.70', '0.00', '2022-05-20'),
(2020, 2, '3339152.40', '0.00', '2022-05-05'),
(2020, 3, '1577390.65', '0.00', '2022-05-20'),
(2020, 4, '534715.58', '592528.24', '2022-10-30'),
(2020, 5, '4956186.54', '0.00', '2022-06-13'),
(2021, 0, '2176097.62', '2441562.14', '2022-11-21'),
(2021, 1, '4118824.01', '5010005.36', '2022-12-15'),
(2021, 2, '3358475.99', '0.00', '2022-09-26'),
(2021, 3, '1534127.25', '0.00', '2022-06-14'),
(2021, 4, '1068389.01', '1114717.31', '2022-12-21'),
(2021, 5, '4069954.82', '0.00', '2022-10-18'),
(2021, 6, '331799.64', '380195.29', '2022-11-21'),
(2022, 0, '2683206.61', '3154690.65', '2023-01-06'),
(2022, 1, '4310173.09', '4966989.67', '2023-01-06'),
(2022, 2, '4392378.49', '4678160.31', '2023-01-06'),
(2022, 3, '1588053.09', '1545146.65', '2023-01-06'),
(2022, 4, '1500689.27', '1493438.24', '2023-01-06'),
(2022, 5, '4897593.83', '5762900.21', '2023-01-06'),
(2022, 6, '1228207.40', '1629143.11', '2023-01-06'),
(2023, 0, '1027944.84', '1321133.68', '2023-01-06'),
(2023, 1, '2952551.42', '3271509.39', '2023-01-04'),
(2023, 2, '3300626.63', '2739473.38', '2023-01-05'),
(2023, 3, '791966.10', '804966.10', '2023-01-02'),
(2023, 4, '753778.95', '944428.95', '2023-01-06'),
(2023, 5, '2407864.98', '3929370.80', '2023-01-05'),
(2023, 6, '1659524.90', '1820803.67', '2023-01-06'),
(2024, 0, '124082.25', '208229.13', '2022-12-06'),
(2024, 1, '1409385.60', '1548610.71', '2022-12-06'),
(2024, 2, '609238.68', '821572.09', '2022-12-15'),
(2024, 3, '109170.00', '109170.00', '2022-12-06'),
(2024, 4, '545292.00', '565692.00', '2022-11-21'),
(2024, 5, '1143758.10', '0.00', '2022-08-26'),
(2024, 6, '48870.00', '0.00', '2022-08-18'),
(2025, 5, '320173.50', '0.00', '2022-08-18');

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

--
-- Struktura tabulky `role`
--

CREATE TABLE `role` (
  `login` varchar(63) COLLATE utf8_czech_ci NOT NULL,
  `id_role` int(11) NOT NULL COMMENT '1=účetní'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `role`
--

INSERT INTO `role` (`login`, `id_role`) VALUES
('plskoeva', 1),
('sestaev1', 1),
('tester4', 2),
('mrkvikat', 2),
('tomeska1', 2),
('kuzmimic', 2),
('holecste', 2),
('steigpat', 2),
('zamprlib', 2),
('burdomic', 2),
('hrachiva', 2);

--
-- Klíče pro exportované tabulky
--

--
-- Klíče pro tabulku `cil_smluvniho_vyzkumu`
--
ALTER TABLE `cil_smluvniho_vyzkumu`
  ADD PRIMARY KEY (`rok`,`RP`);

--
-- Klíče pro tabulku `granty_temp`
--
ALTER TABLE `granty_temp`
  ADD PRIMARY KEY (`id`);

--
-- Klíče pro tabulku `jine_naklady`
--
ALTER TABLE `jine_naklady`
  ADD PRIMARY KEY (`id`);

--
-- Klíče pro tabulku `kpi_impaktovane_publikace`
--
ALTER TABLE `kpi_impaktovane_publikace`
  ADD PRIMARY KEY (`id`);

--
-- Klíče pro tabulku `opravneni_rp`
--
ALTER TABLE `opravneni_rp`
  ADD PRIMARY KEY (`login`,`RP`);

--
-- Klíče pro tabulku `plan_obchodu`
--
ALTER TABLE `plan_obchodu`
  ADD PRIMARY KEY (`id`);

--
-- Klíče pro tabulku `report_dalsi_udaje`
--
ALTER TABLE `report_dalsi_udaje`
  ADD PRIMARY KEY (`RP`,`rok`);

--
-- Klíče pro tabulku `report_objem_rezii_vsech_rp`
--
ALTER TABLE `report_objem_rezii_vsech_rp`
  ADD PRIMARY KEY (`rok`,`RP`);

--
-- AUTO_INCREMENT pro tabulky
--

--
-- AUTO_INCREMENT pro tabulku `granty_temp`
--
ALTER TABLE `granty_temp`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45126;

--
-- AUTO_INCREMENT pro tabulku `jine_naklady`
--
ALTER TABLE `jine_naklady`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pro tabulku `kpi_impaktovane_publikace`
--
ALTER TABLE `kpi_impaktovane_publikace`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT pro tabulku `plan_obchodu`
--
ALTER TABLE `plan_obchodu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
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 */;
