-- --------------------------------------------------------
-- Host:                         192.168.2.204
-- Server versie:                8.0.40-0ubuntu0.24.04.1 - (Ubuntu)
-- Server OS:                    Linux
-- HeidiSQL Versie:              12.8.0.6908
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- Dumpen data van tabel p1.deco: ~6 rows (ongeveer)
INSERT INTO `deco` (`id`, `naam`, `categorie`) VALUES
	(1, 'Kosten_Verbruik_Laag', 'Kosten'),
	(2, 'Kosten_Verbruik_Normaal', 'Kosten'),
	(3, 'Corr_Kosten_Verbruik_Gas', 'KostenGas'),
	(4, 'Vaste_Kosten', 'KostenVast'),
	(5, 'Opbrengst_Retour_Laag', 'Opbrengsten'),
	(6, 'Opbrengst_Retour_Normaal', 'Opbrengsten');

-- Dumpen data van tabel p1.tarieven: ~60 rows (ongeveer)
INSERT INTO `tarieven` (`maand`, `tarief_laag`, `tarief_normaal`, `retour_factor_laag`, `retour_factor_normaal`, `tarief_gas`, `dagen`, `vermindering_energiebelasting`, `stroom_transport`, `gas_transport`, `vaste_leveringskosten`, `correctie_gas`) VALUES
	('2020-01-01', 0.19787, 0.20997, 1.00000, 1.00000, 0.64509, 31, -26.35000, 21.39000, 16.12000, 2.50000, 1.01346),
	('2020-02-01', 0.19787, 0.20997, 1.00000, 1.00000, 0.64509, 29, -24.65000, 20.01000, 15.08000, 2.50000, 1.01405),
	('2020-03-01', 0.19787, 0.20997, 1.00000, 1.00000, 0.64509, 31, -26.35000, 21.39000, 16.12000, 2.50000, 1.01783),
	('2020-04-01', 0.19787, 0.20997, 1.00000, 1.00000, 0.64509, 30, -25.50000, 20.70000, 15.60000, 2.50000, 1.01766),
	('2020-05-01', 0.19787, 0.20997, 1.00000, 1.00000, 0.64509, 31, -26.35000, 21.39000, 16.12000, 2.50000, 1.01919),
	('2020-06-01', 0.19787, 0.20997, 1.00000, 1.00000, 0.64509, 30, -25.50000, 20.70000, 15.60000, 2.50000, 1.01785),
	('2020-07-01', 0.19787, 0.20997, 1.00000, 1.00000, 0.64509, 31, -26.35000, 21.39000, 16.12000, 2.50000, 1.01927),
	('2020-08-01', 0.19787, 0.20997, 1.00000, 1.00000, 0.64509, 31, -26.35000, 21.39000, 16.12000, 2.50000, 1.01943),
	('2020-09-01', 0.19787, 0.20997, 1.00000, 1.00000, 0.64509, 30, -25.50000, 20.70000, 15.60000, 2.50000, 1.01672),
	('2020-10-01', 0.19787, 0.20997, 1.00000, 1.00000, 0.64509, 31, -26.35000, 21.39000, 16.12000, 2.50000, 1.01840),
	('2020-11-01', 0.19787, 0.20997, 1.00000, 1.00000, 0.64509, 30, -25.50000, 20.70000, 15.60000, 2.50000, 1.01835),
	('2020-12-01', 0.19787, 0.20997, 1.00000, 1.00000, 0.64509, 31, -26.35000, 21.39000, 16.12000, 2.50000, 1.01605),
	('2021-01-01', 0.16676, 0.18231, 1.00000, 1.00000, 0.72224, 31, -44.75005, 23.28999, 17.37271, 6.98000, 1.01645),
	('2021-02-01', 0.16676, 0.18231, 1.00000, 1.00000, 0.72224, 28, -40.41940, 21.03612, 15.69148, 6.98000, 1.01752),
	('2021-03-01', 0.16676, 0.18231, 1.00000, 1.00000, 0.72224, 31, -44.75005, 23.28999, 17.37271, 6.98000, 1.01732),
	('2021-04-01', 0.16676, 0.18231, 1.00000, 1.00000, 0.72224, 30, -43.30650, 22.53870, 16.81230, 6.98000, 1.01934),
	('2021-05-01', 0.16676, 0.18231, 1.00000, 1.00000, 0.72224, 31, -44.75005, 23.28999, 17.37271, 6.98000, 1.01953),
	('2021-06-01', 0.16676, 0.18231, 1.00000, 1.00000, 0.72224, 30, -43.30650, 22.53870, 16.81230, 6.98000, 1.02055),
	('2021-07-01', 0.16676, 0.18231, 1.00000, 1.00000, 0.72224, 31, -44.75005, 23.28999, 17.37271, 6.98000, 1.02064),
	('2021-08-01', 0.16676, 0.18231, 1.00000, 1.00000, 0.72224, 31, -44.75005, 23.28999, 17.37271, 6.98000, 1.02247),
	('2021-09-01', 0.16676, 0.18231, 1.00000, 1.00000, 0.72224, 30, -43.30650, 22.53870, 16.81230, 6.98000, 1.02505),
	('2021-10-01', 0.16676, 0.18231, 1.00000, 1.00000, 0.72224, 31, -44.75005, 23.28999, 17.37271, 6.98000, 1.02465),
	('2021-11-01', 0.16676, 0.18231, 1.00000, 1.00000, 0.72224, 30, -43.30650, 22.53870, 16.81230, 6.98000, 1.02374),
	('2021-12-01', 0.16676, 0.18231, 1.00000, 1.00000, 0.72224, 31, -44.75005, 23.28999, 17.37271, 6.98000, 1.02106),
	('2022-01-01', 0.35770, 0.36980, 1.00000, 1.00000, 1.61201, 31, -57.83670, 23.41027, 16.99885, 11.98000, 1.02192),
	('2022-02-01', 0.46941, 0.60512, 1.00000, 1.00000, 2.11704, 28, -52.23960, 21.14476, 15.35380, 11.98000, 1.02105),
	('2022-03-01', 0.34732, 0.40237, 1.00000, 1.00000, 1.66410, 31, -57.83670, 23.41027, 16.99885, 11.98000, 1.02238),
	('2022-04-01', 0.42115, 0.55158, 1.00000, 1.00000, 2.12216, 30, -55.97100, 22.65510, 16.45050, 11.98000, 1.02113),
	('2022-05-01', 0.45059, 0.50430, 1.00000, 1.00000, 2.13685, 31, -57.83670, 23.41027, 16.99885, 11.98000, 1.02498),
	('2022-06-01', 0.43423, 0.49268, 1.00000, 1.00000, 1.99536, 30, -55.97100, 22.65510, 16.45050, 11.98000, 1.02513),
	('2022-07-01', 0.42191, 0.47052, 1.00000, 1.00000, 1.89177, 31, -57.83670, 23.41027, 16.99885, 11.98000, 1.02142),
	('2022-08-01', 0.42896, 0.47029, 1.00000, 1.00000, 1.68215, 31, -57.83670, 23.41027, 16.99885, 11.98000, 1.02120),
	('2022-09-01', 0.58335, 0.69210, 1.00000, 1.00000, 2.29774, 30, -55.97100, 22.65510, 16.45050, 11.98000, 1.02033),
	('2022-10-01', 0.69752, 0.75704, 1.00000, 1.00000, 2.66664, 31, -57.83670, 23.41027, 16.99885, 11.98000, 1.02241),
	('2022-11-01', 0.78039, 0.82130, 1.00000, 0.45872, 2.89935, 30, -55.97100, 22.65510, 16.45050, 11.98000, 1.02067),
	('2022-12-01', 0.57465, 0.60100, 1.00000, 0.45872, 2.41353, 31, -57.83670, 23.41027, 16.99885, 11.98000, 1.02049),
	('2023-01-01', 0.40000, 0.40000, 1.00000, 1.00000, 1.45000, 31, -50.69120, 23.56000, 17.67000, 11.98000, 1.02095),
	('2023-02-01', 0.40000, 0.40000, 1.00000, 1.00000, 1.45000, 28, -45.78560, 21.28000, 15.96000, 11.98000, 1.02058),
	('2023-03-01', 0.40000, 0.40000, 1.00000, 1.00000, 1.45000, 31, -50.69120, 23.56000, 17.67000, 11.98000, 1.01694),
	('2023-04-01', 0.39282, 0.40000, 1.00000, 1.00000, 1.42803, 30, -49.05600, 22.80000, 17.10000, 11.98000, 1.01635),
	('2023-05-01', 0.36711, 0.39246, 1.00000, 1.00000, 1.24586, 31, -50.69120, 23.56000, 17.67000, 11.98000, 1.01823),
	('2023-06-01', 0.36711, 0.39246, 1.00000, 1.00000, 1.24586, 30, -49.05600, 22.80000, 17.10000, 11.98000, 1.01571),
	('2023-07-01', 0.29390, 0.30660, 1.00000, 1.00000, 1.14805, 31, -50.55000, 29.42000, 20.40000, 11.98000, 1.01402),
	('2023-08-01', 0.29390, 0.30660, 1.00000, 1.00000, 1.14805, 31, -50.55000, 29.42000, 20.40000, 19.86000, 1.01460),
	('2023-09-01', 0.29390, 0.30660, 1.00000, 1.00000, 1.14805, 30, -48.92000, 28.47000, 19.73000, 19.86000, 1.01602),
	('2023-10-01', 0.29390, 0.30660, 1.00000, 1.00000, 1.14805, 31, -50.55000, 29.42000, 20.40000, 19.86000, 1.01486),
	('2023-11-01', 0.29390, 0.30660, 1.00000, 1.00000, 1.14805, 30, -48.92000, 28.47000, 19.73000, 19.86000, 1.01453),
	('2024-01-01', 0.29390, 0.30660, 1.00000, 1.00000, 1.14805, 31, -50.55000, 29.42000, 20.40000, 19.86000, 1.01807),
	('2024-02-01', 0.29390, 0.30660, 1.00000, 1.00000, 1.14805, 29, -47.29000, 27.52000, 19.08000, 19.86000, 1.01961),
	('2024-03-01', 0.29390, 0.30660, 1.00000, 1.00000, 1.14805, 31, -50.55000, 29.42000, 20.40000, 19.86000, 1.01817),
	('2024-04-01', 0.29390, 0.30660, 1.00000, 1.00000, 1.14805, 30, -48.92000, 28.47000, 19.73000, 19.86000, 1.01747),
	('2024-05-01', 0.29390, 0.30660, 1.00000, 1.00000, 1.14805, 31, -50.55000, 29.42000, 20.40000, 19.86000, 1.01924),
	('2024-06-01', 0.29390, 0.30660, 1.00000, 1.00000, 1.14805, 30, -48.92000, 28.47000, 19.73000, 19.86000, 1.01980),
	('2024-07-01', 0.23950, 0.26610, 1.00000, 1.00000, 1.15834, 31, -53.62000, 33.96000, 20.93000, 32.50000, 1.02067),
	('2024-08-01', 0.23950, 0.26610, 1.00000, 1.00000, 1.15834, 31, -53.62000, 33.96000, 20.93000, 32.50000, 1.02067),
	('2024-09-01', 0.23950, 0.26610, 1.00000, 1.00000, 1.15834, 30, -51.90000, 32.86000, 20.26000, 32.50000, 1.02067),
	('2024-11-01', 0.23950, 0.26610, 1.00000, 1.00000, 1.15834, 30, -51.90000, 32.86000, 20.26000, 32.50000, 1.02067),
	('2024-12-01', 0.23950, 0.26610, 1.00000, 1.00000, 1.15834, 31, -53.62000, 33.96000, 20.93000, 32.50000, 1.02067),
	('2023-12-01', 0.29390, 0.30660, 1.00000, 1.00000, 1.14805, 31, -50.55000, 29.42000, 20.40000, 19.86000, 1.01557),
	('2024-10-01', 0.23950, 0.26610, 1.00000, 1.00000, 1.15834, 31, -53.62000, 33.96000, 20.93000, 32.50000, 1.02067);

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
