configSLASHpython_scriptsSLASHprijsplafond.py

dagtabel = [{"datum": "1-1-2023", "stroom": 11.321629, "gas": 7.17361783}, {"datum": "2-1-2023", "stroom": 11.151776, "gas": 7.29365989}, {"datum": "3-1-2023", "stroom": 10.814767, "gas": 7.50814813}, {"datum": "4-1-2023", "stroom": 10.933145, "gas": 7.46678924}, {"datum": "5-1-2023", "stroom": 10.867808, "gas": 7.40948305}, {"datum": "6-1-2023", "stroom": 10.874362, "gas": 7.12583471}, {"datum": "7-1-2023", "stroom": 11.547017, "gas": 7.06297627}, {"datum": "8-1-2023", "stroom": 11.609251, "gas": 6.90513601}, {"datum": "9-1-2023", "stroom": 10.888195, "gas": 6.93128915}, {"datum": "10-1-2023", "stroom": 10.611738, "gas": 6.9051776}, {"datum": "11-1-2023", "stroom": 10.735336, "gas": 6.94681715}, {"datum": "12-1-2023", "stroom": 10.606315, "gas": 6.92379916}, {"datum": "13-1-2023", "stroom": 10.791567, "gas": 6.69227866}, {"datum": "14-1-2023", "stroom": 11.522976, "gas": 6.74976235}, {"datum": "15-1-2023", "stroom": 11.617777, "gas": 6.72370085}, {"datum": "16-1-2023", "stroom": 10.779735, "gas": 6.90239464}, {"datum": "17-1-2023", "stroom": 10.637142, "gas": 6.96068977}, {"datum": "18-1-2023", "stroom": 10.592714, "gas": 7.08851374}, {"datum": "19-1-2023", "stroom": 10.389801, "gas": 7.00058675}, {"datum": "20-1-2023", "stroom": 10.798875, "gas": 6.98597455}, {"datum": "21-1-2023", "stroom": 11.48632, "gas": 7.12991528}, {"datum": "22-1-2023", "stroom": 11.563054, "gas": 7.19546986}, {"datum": "23-1-2023", "stroom": 10.815985, "gas": 7.43678302}, {"datum": "24-1-2023", "stroom": 10.70622, "gas": 7.35814823}, {"datum": "25-1-2023", "stroom": 10.710802, "gas": 7.49728597}, {"datum": "26-1-2023", "stroom": 10.4052, "gas": 7.56062596}, {"datum": "27-1-2023", "stroom": 10.616436, "gas": 7.31163871}, {"datum": "28-1-2023", "stroom": 11.463526, "gas": 7.23298964}, {"datum": "29-1-2023", "stroom": 11.448301, "gas": 7.10172329}, {"datum": "30-1-2023", "stroom": 10.702218, "gas": 7.19504536}, {"datum": "31-1-2023", "stroom": 10.489358, "gas": 7.37483185}, {"datum": "1-2-2023", "stroom": 10.519083, "gas": 7.39434818}, {"datum": "2-2-2023", "stroom": 10.186772, "gas": 7.16656154}, {"datum": "3-2-2023", "stroom": 10.316489, "gas": 6.79139149}, {"datum": "4-2-2023", "stroom": 11.261048, "gas": 6.76650941}, {"datum": "5-2-2023", "stroom": 11.521497, "gas": 6.53328173}, {"datum": "6-2-2023", "stroom": 10.646596, "gas": 6.69376133}, {"datum": "7-2-2023", "stroom": 10.330003, "gas": 6.97538503}, {"datum": "8-2-2023", "stroom": 10.29848, "gas": 7.14112236}, {"datum": "9-2-2023", "stroom": 10.120275, "gas": 7.22550605}, {"datum": "10-2-2023", "stroom": 10.289374, "gas": 7.18161464}, {"datum": "11-2-2023", "stroom": 11.059556, "gas": 6.99223027}, {"datum": "12-2-2023", "stroom": 11.251913, "gas": 6.8513672}, {"datum": "13-2-2023", "stroom": 10.304251, "gas": 7.05662366}, {"datum": "14-2-2023", "stroom": 9.688175, "gas": 7.02768284}, {"datum": "15-2-2023", "stroom": 9.761052, "gas": 6.75782404}, {"datum": "16-2-2023", "stroom": 9.708185, "gas": 6.56174147}, {"datum": "17-2-2023", "stroom": 9.723468, "gas": 6.48236336}, {"datum": "18-2-2023", "stroom": 10.125843, "gas": 6.51979424}, {"datum": "19-2-2023", "stroom": 10.088172, "gas": 6.62183914}, {"datum": "20-2-2023", "stroom": 9.582209, "gas": 6.62736338}, {"datum": "21-2-2023", "stroom": 8.822438, "gas": 6.68609065}, {"datum": "22-2-2023", "stroom": 8.864227, "gas": 6.69458268}, {"datum": "23-2-2023", "stroom": 9.131549, "gas": 6.53537825}, {"datum": "24-2-2023", "stroom": 9.083699, "gas": 6.25175401}, {"datum": "25-2-2023", "stroom": 9.615443, "gas": 6.08763773}, {"datum": "26-2-2023", "stroom": 9.930615, "gas": 5.98658881}, {"datum": "27-2-2023", "stroom": 9.216896, "gas": 6.18420619}, {"datum": "28-2-2023", "stroom": 8.564686, "gas": 6.21955242}, {"datum": "1-3-2023", "stroom": 8.708265, "gas": 6.33414223}, {"datum": "2-3-2023", "stroom": 9.024655, "gas": 6.3920358}, {"datum": "3-3-2023", "stroom": 9.018188, "gas": 6.38074567}, {"datum": "4-3-2023", "stroom": 9.7324, "gas": 6.1333713}, {"datum": "5-3-2023", "stroom": 10.161049, "gas": 5.81858212}, {"datum": "6-3-2023", "stroom": 9.085961, "gas": 5.87373527}, {"datum": "7-3-2023", "stroom": 8.573009, "gas": 5.63116308}, {"datum": "8-3-2023", "stroom": 8.853497, "gas": 5.49814379}, {"datum": "9-3-2023", "stroom": 8.859065, "gas": 5.41436083}, {"datum": "10-3-2023", "stroom": 8.870694, "gas": 5.35144112}, {"datum": "11-3-2023", "stroom": 9.608599, "gas": 5.4200091}, {"datum": "12-3-2023", "stroom": 9.751627, "gas": 5.14192746}, {"datum": "13-3-2023", "stroom": 8.779924, "gas": 5.34588974}, {"datum": "14-3-2023", "stroom": 8.480499, "gas": 5.30233717}, {"datum": "15-3-2023", "stroom": 8.699217, "gas": 5.05722134}, {"datum": "16-3-2023", "stroom": 8.663344, "gas": 4.85703858}, {"datum": "17-3-2023", "stroom": 8.598471, "gas": 4.86955706}, {"datum": "18-3-2023", "stroom": 9.250565, "gas": 4.9993197}, {"datum": "19-3-2023", "stroom": 9.211821, "gas": 4.96335972}, {"datum": "20-3-2023", "stroom": 8.555725, "gas": 5.06943626}, {"datum": "21-3-2023", "stroom": 8.33257, "gas": 5.06784216}, {"datum": "22-3-2023", "stroom": 8.130034, "gas": 4.96086198}, {"datum": "23-3-2023", "stroom": 8.214511, "gas": 4.84258328}, {"datum": "24-3-2023", "stroom": 8.031173, "gas": 4.53696997}, {"datum": "25-3-2023", "stroom": 8.647481, "gas": 4.37508967}, {"datum": "26-3-2023", "stroom": 8.287736, "gas": 4.55934398}, {"datum": "27-3-2023", "stroom": 7.73401, "gas": 4.49977616}, {"datum": "28-3-2023", "stroom": 7.08122, "gas": 4.55496799}, {"datum": "29-3-2023", "stroom": 7.418751, "gas": 4.19289924}, {"datum": "30-3-2023", "stroom": 7.404657, "gas": 3.69225967}, {"datum": "31-3-2023", "stroom": 7.592983, "gas": 3.47473025}, {"datum": "1-4-2023", "stroom": 8.079777, "gas": 3.37406227}, {"datum": "2-4-2023", "stroom": 8.137023, "gas": 3.13616214}, {"datum": "3-4-2023", "stroom": 7.342858, "gas": 3.42950266}, {"datum": "4-4-2023", "stroom": 7.053496, "gas": 3.8634897}, {"datum": "5-4-2023", "stroom": 7.270503, "gas": 4.17129634}, {"datum": "6-4-2023", "stroom": 7.100186, "gas": 4.0048733}, {"datum": "7-4-2023", "stroom": 7.303998, "gas": 3.5640263}, {"datum": "8-4-2023", "stroom": 8.019138, "gas": 3.47990668}, {"datum": "9-4-2023", "stroom": 7.758457, "gas": 3.10103989}, {"datum": "10-4-2023", "stroom": 7.375831, "gas": 3.12204805}, {"datum": "11-4-2023", "stroom": 6.963016, "gas": 3.29015648}, {"datum": "12-4-2023", "stroom": 6.94666, "gas": 3.43146997}, {"datum": "13-4-2023", "stroom": 6.647699, "gas": 3.68846788}, {"datum": "14-4-2023", "stroom": 6.722635, "gas": 3.3293311}, {"datum": "15-4-2023", "stroom": 7.416199, "gas": 3.06104812}, {"datum": "16-4-2023", "stroom": 7.035284, "gas": 2.81264011}, {"datum": "17-4-2023", "stroom": 6.676003, "gas": 2.9624469}, {"datum": "18-4-2023", "stroom": 6.303382, "gas": 2.93833466}, {"datum": "19-4-2023", "stroom": 6.223864, "gas": 2.89785233}, {"datum": "20-4-2023", "stroom": 6.255561, "gas": 2.51750236}, {"datum": "21-4-2023", "stroom": 6.188339, "gas": 2.172746}, {"datum": "22-4-2023", "stroom": 6.830834, "gas": 2.00642815}, {"datum": "23-4-2023", "stroom": 6.592309, "gas": 1.86792547}, {"datum": "24-4-2023", "stroom": 6.253589, "gas": 1.83656459}, {"datum": "25-4-2023", "stroom": 5.979423, "gas": 1.86647537}, {"datum": "26-4-2023", "stroom": 5.981221, "gas": 1.95518306}, {"datum": "27-4-2023", "stroom": 6.702422, "gas": 1.91831654}, {"datum": "28-4-2023", "stroom": 6.401808, "gas": 2.09209433}, {"datum": "29-4-2023", "stroom": 6.810389, "gas": 2.0167141}, {"datum": "30-4-2023", "stroom": 6.827731, "gas": 1.81858578}, {"datum": "1-5-2023", "stroom": 6.166821, "gas": 1.60206209}, {"datum": "2-5-2023", "stroom": 6.178508, "gas": 1.61957664}, {"datum": "3-5-2023", "stroom": 6.143911, "gas": 1.60384111}, {"datum": "4-5-2023", "stroom": 6.187933, "gas": 1.69101241}, {"datum": "5-5-2023", "stroom": 6.03635, "gas": 1.6423665}, {"datum": "6-5-2023", "stroom": 6.55603, "gas": 1.57653253}, {"datum": "7-5-2023", "stroom": 6.468827, "gas": 1.32181553}, {"datum": "8-5-2023", "stroom": 5.9044, "gas": 1.35462656}, {"datum": "9-5-2023", "stroom": 5.740086, "gas": 1.15338499}, {"datum": "10-5-2023", "stroom": 5.777525, "gas": 1.12296589}, {"datum": "11-5-2023", "stroom": 5.736345, "gas": 1.18614508}, {"datum": "12-5-2023", "stroom": 5.710448, "gas": 1.26037852}, {"datum": "13-5-2023", "stroom": 6.294566, "gas": 1.12140696}, {"datum": "14-5-2023", "stroom": 6.310052, "gas": 1.21073387}, {"datum": "15-5-2023", "stroom": 5.791474, "gas": 1.2450091}, {"datum": "16-5-2023", "stroom": 5.659698, "gas": 1.1967596}, {"datum": "17-5-2023", "stroom": 5.555124, "gas": 1.18517618}, {"datum": "18-5-2023", "stroom": 6.252197, "gas": 1.02318482}, {"datum": "19-5-2023", "stroom": 5.74345, "gas": 0.96128749}, {"datum": "20-5-2023", "stroom": 6.010424, "gas": 0.8158073}, {"datum": "21-5-2023", "stroom": 6.210669, "gas": 0.88714532}, {"datum": "22-5-2023", "stroom": 5.667035, "gas": 0.90468481}, {"datum": "23-5-2023", "stroom": 5.615705, "gas": 0.8695861}, {"datum": "24-5-2023", "stroom": 5.445388, "gas": 0.85710858}, {"datum": "25-5-2023", "stroom": 5.442662, "gas": 0.83091895}, {"datum": "26-5-2023", "stroom": 5.23247, "gas": 0.84871555}, {"datum": "27-5-2023", "stroom": 5.494804, "gas": 0.79069552}, {"datum": "28-5-2023", "stroom": 5.647953, "gas": 0.81712562}, {"datum": "29-5-2023", "stroom": 5.558662, "gas": 0.77404646}, {"datum": "30-5-2023", "stroom": 5.280407, "gas": 0.71923118}, {"datum": "31-5-2023", "stroom": 5.31802, "gas": 0.69844573}, {"datum": "1-6-2023", "stroom": 5.484219, "gas": 0.67137725}, {"datum": "2-6-2023", "stroom": 5.4114, "gas": 0.65331774}, {"datum": "3-6-2023", "stroom": 5.606483, "gas": 0.65264522}, {"datum": "4-6-2023", "stroom": 5.504026, "gas": 0.69033146}, {"datum": "5-6-2023", "stroom": 5.190855, "gas": 0.68549868}, {"datum": "6-6-2023", "stroom": 5.09965, "gas": 0.68327159}, {"datum": "7-6-2023", "stroom": 5.29888, "gas": 0.67334834}, {"datum": "8-6-2023", "stroom": 5.243867, "gas": 0.6671072}, {"datum": "9-6-2023", "stroom": 5.315439, "gas": 0.68183083}, {"datum": "10-6-2023", "stroom": 5.692874, "gas": 0.62803514}, {"datum": "11-6-2023", "stroom": 5.64195, "gas": 0.64351399}, {"datum": "12-6-2023", "stroom": 5.178588, "gas": 0.62778155}, {"datum": "13-6-2023", "stroom": 5.132014, "gas": 0.62322211}, {"datum": "14-6-2023", "stroom": 5.33687, "gas": 0.60647658}, {"datum": "15-6-2023", "stroom": 5.312017, "gas": 0.59900252}, {"datum": "16-6-2023", "stroom": 5.316715, "gas": 0.62671348}, {"datum": "17-6-2023", "stroom": 5.416562, "gas": 0.56840167}, {"datum": "18-6-2023", "stroom": 5.570407, "gas": 0.63051601}, {"datum": "19-6-2023", "stroom": 5.263152, "gas": 0.60524975}, {"datum": "20-6-2023", "stroom": 5.109655, "gas": 0.6038147}, {"datum": "21-6-2023", "stroom": 5.205181, "gas": 0.5848005}, {"datum": "22-6-2023", "stroom": 5.316106, "gas": 0.60646592}, {"datum": "23-6-2023", "stroom": 5.246912, "gas": 0.63832346}, {"datum": "24-6-2023", "stroom": 5.461193, "gas": 0.61693966}, {"datum": "25-6-2023", "stroom": 5.54683, "gas": 0.62504214}, {"datum": "26-6-2023", "stroom": 5.214664, "gas": 0.57042036}, {"datum": "27-6-2023", "stroom": 5.081525, "gas": 0.56796326}, {"datum": "28-6-2023", "stroom": 5.078016, "gas": 0.56537989}, {"datum": "29-6-2023", "stroom": 5.044724, "gas": 0.57959834}, {"datum": "30-6-2023", "stroom": 4.979039, "gas": 0.5622769}, {"datum": "1-7-2023", "stroom": 5.47317, "gas": 0.55953127}, {"datum": "2-7-2023", "stroom": 5.538594, "gas": 0.58038446}, {"datum": "3-7-2023", "stroom": 5.164639, "gas": 0.5661326}, {"datum": "4-7-2023", "stroom": 5.032834, "gas": 0.55614494}, {"datum": "5-7-2023", "stroom": 5.093415, "gas": 0.54503117}, {"datum": "6-7-2023", "stroom": 4.982142, "gas": 0.54999786}, {"datum": "7-7-2023", "stroom": 5.011577, "gas": 0.54674671}, {"datum": "8-7-2023", "stroom": 5.448897, "gas": 0.55009128}, {"datum": "9-7-2023", "stroom": 5.570842, "gas": 0.59383794}, {"datum": "10-7-2023", "stroom": 5.207762, "gas": 0.55603008}, {"datum": "11-7-2023", "stroom": 5.109191, "gas": 0.56114256}, {"datum": "12-7-2023", "stroom": 5.084367, "gas": 0.57363995}, {"datum": "13-7-2023", "stroom": 5.072796, "gas": 0.56241896}, {"datum": "14-7-2023", "stroom": 5.032689, "gas": 0.57818165}, {"datum": "15-7-2023", "stroom": 5.281741, "gas": 0.54429919}, {"datum": "16-7-2023", "stroom": 5.399974, "gas": 0.56796701}, {"datum": "17-7-2023", "stroom": 5.038344, "gas": 0.54732128}, {"datum": "18-7-2023", "stroom": 5.097707, "gas": 0.5481287}, {"datum": "19-7-2023", "stroom": 5.103014, "gas": 0.54021942}, {"datum": "20-7-2023", "stroom": 5.219623, "gas": 0.54267691}, {"datum": "21-7-2023", "stroom": 5.110496, "gas": 0.53977651}, {"datum": "22-7-2023", "stroom": 5.461193, "gas": 0.5384846}, {"datum": "23-7-2023", "stroom": 5.346353, "gas": 0.56499448}, {"datum": "24-7-2023", "stroom": 5.002442, "gas": 0.547195}, {"datum": "25-7-2023", "stroom": 5.04281, "gas": 0.54254719}, {"datum": "26-7-2023", "stroom": 5.069432, "gas": 0.54281489}, {"datum": "27-7-2023", "stroom": 5.106929, "gas": 0.54540694}, {"datum": "28-7-2023", "stroom": 5.106378, "gas": 0.5328153}, {"datum": "29-7-2023", "stroom": 5.467834, "gas": 0.53998415}, {"datum": "30-7-2023", "stroom": 5.2345, "gas": 0.56067566}, {"datum": "31-7-2023", "stroom": 5.060123, "gas": 0.54111043}, {"datum": "1-8-2023", "stroom": 4.921909, "gas": 0.53567102}, {"datum": "2-8-2023", "stroom": 4.963466, "gas": 0.53514}, {"datum": "3-8-2023", "stroom": 4.914862, "gas": 0.53514}, {"datum": "4-8-2023", "stroom": 5.144426, "gas": 0.5253}, {"datum": "5-8-2023", "stroom": 5.631655, "gas": 0.53374975}, {"datum": "6-8-2023", "stroom": 5.556835, "gas": 0.54899698}, {"datum": "7-8-2023", "stroom": 5.541059, "gas": 0.54093034}, {"datum": "8-8-2023", "stroom": 5.222088, "gas": 0.5422708}, {"datum": "9-8-2023", "stroom": 5.34441, "gas": 0.54683204}, {"datum": "10-8-2023", "stroom": 5.44475, "gas": 0.54717354}, {"datum": "11-8-2023", "stroom": 5.549585, "gas": 0.54480494}, {"datum": "12-8-2023", "stroom": 6.045949, "gas": 0.54031513}, {"datum": "13-8-2023", "stroom": 6.098149, "gas": 0.56252779}, {"datum": "14-8-2023", "stroom": 5.945986, "gas": 0.55014626}, {"datum": "15-8-2023", "stroom": 5.629161, "gas": 0.54058578}, {"datum": "16-8-2023", "stroom": 5.649983, "gas": 0.53738905}, {"datum": "17-8-2023", "stroom": 5.856521, "gas": 0.55425887}, {"datum": "18-8-2023", "stroom": 5.718307, "gas": 0.54794138}, {"datum": "19-8-2023", "stroom": 5.928731, "gas": 0.54873619}, {"datum": "20-8-2023", "stroom": 6.148522, "gas": 0.56150334}, {"datum": "21-8-2023", "stroom": 5.805626, "gas": 0.54844692}, {"datum": "22-8-2023", "stroom": 5.728486, "gas": 0.55896661}, {"datum": "23-8-2023", "stroom": 5.762648, "gas": 0.56550066}, {"datum": "24-8-2023", "stroom": 5.773088, "gas": 0.5682563}, {"datum": "25-8-2023", "stroom": 5.849561, "gas": 0.57024144}, {"datum": "26-8-2023", "stroom": 6.018544, "gas": 0.56373832}, {"datum": "27-8-2023", "stroom": 6.443539, "gas": 0.60008246}, {"datum": "28-8-2023", "stroom": 5.891756, "gas": 0.58213879}, {"datum": "29-8-2023", "stroom": 5.898165, "gas": 0.62706535}, {"datum": "30-8-2023", "stroom": 5.994822, "gas": 0.62469466}, {"datum": "31-8-2023", "stroom": 5.90005, "gas": 0.61423171}, {"datum": "1-9-2023", "stroom": 6.012773, "gas": 0.58928904}, {"datum": "2-9-2023", "stroom": 6.251588, "gas": 0.55941635}, {"datum": "3-9-2023", "stroom": 6.672581, "gas": 0.63402464}, {"datum": "4-9-2023", "stroom": 6.026577, "gas": 0.65885335}, {"datum": "5-9-2023", "stroom": 5.964198, "gas": 0.65388412}, {"datum": "6-9-2023", "stroom": 6.189528, "gas": 0.65097845}, {"datum": "7-9-2023", "stroom": 6.090348, "gas": 0.65822159}, {"datum": "8-9-2023", "stroom": 6.062131, "gas": 0.65170182}, {"datum": "9-9-2023", "stroom": 6.542835, "gas": 0.61614016}, {"datum": "10-9-2023", "stroom": 6.75091, "gas": 0.68267237}, {"datum": "11-9-2023", "stroom": 6.260375, "gas": 0.67214809}, {"datum": "12-9-2023", "stroom": 6.254894, "gas": 0.67865315}, {"datum": "13-9-2023", "stroom": 6.372083, "gas": 0.74551014}, {"datum": "14-9-2023", "stroom": 6.197474, "gas": 0.84495514}, {"datum": "15-9-2023", "stroom": 6.280965, "gas": 0.8573852}, {"datum": "16-9-2023", "stroom": 6.633402, "gas": 0.80558136}, {"datum": "17-9-2023", "stroom": 6.928622, "gas": 0.89469236}, {"datum": "18-9-2023", "stroom": 6.566325, "gas": 0.90856757}, {"datum": "19-9-2023", "stroom": 6.467754, "gas": 0.9047651}, {"datum": "20-9-2023", "stroom": 6.480543, "gas": 0.89446666}, {"datum": "21-9-2023", "stroom": 6.609709, "gas": 0.83622768}, {"datum": "22-9-2023", "stroom": 6.773907, "gas": 0.83826014}, {"datum": "23-9-2023", "stroom": 6.947704, "gas": 0.81265447}, {"datum": "24-9-2023", "stroom": 7.66876, "gas": 0.94133995}, {"datum": "25-9-2023", "stroom": 7.094647, "gas": 0.95566073}, {"datum": "26-9-2023", "stroom": 6.921198, "gas": 0.9663058}, {"datum": "27-9-2023", "stroom": 7.165233, "gas": 0.96224534}, {"datum": "28-9-2023", "stroom": 7.453464, "gas": 1.02139183}, {"datum": "29-9-2023", "stroom": 7.584921, "gas": 1.11909116}, {"datum": "30-9-2023", "stroom": 8.006233, "gas": 1.24319872}, {"datum": "1-10-2023", "stroom": 8.710585, "gas": 1.57043478}, {"datum": "2-10-2023", "stroom": 7.898498, "gas": 1.76777894}, {"datum": "3-10-2023", "stroom": 7.675604, "gas": 1.81455061}, {"datum": "4-10-2023", "stroom": 7.971578, "gas": 1.90907052}, {"datum": "5-10-2023", "stroom": 7.941447, "gas": 1.99894022}, {"datum": "6-10-2023", "stroom": 8.099091, "gas": 2.11086835}, {"datum": "7-10-2023", "stroom": 8.63011, "gas": 2.07794884}, {"datum": "8-10-2023", "stroom": 8.975906, "gas": 1.90463772}, {"datum": "9-10-2023", "stroom": 8.259316, "gas": 2.04317806}, {"datum": "10-10-2023", "stroom": 7.985527, "gas": 2.10946619}, {"datum": "11-10-2023", "stroom": 8.30473, "gas": 2.21119639}, {"datum": "12-10-2023", "stroom": 8.107472, "gas": 2.32430322}, {"datum": "13-10-2023", "stroom": 8.213815, "gas": 2.31905846}, {"datum": "14-10-2023", "stroom": 8.712876, "gas": 2.36815397}, {"datum": "15-10-2023", "stroom": 8.94331, "gas": 2.29131431}, {"datum": "16-10-2023", "stroom": 8.423601, "gas": 2.61299417}, {"datum": "17-10-2023", "stroom": 8.183307, "gas": 2.75403059}, {"datum": "18-10-2023", "stroom": 8.450194, "gas": 2.94665803}, {"datum": "19-10-2023", "stroom": 8.339704, "gas": 2.89336418}, {"datum": "20-10-2023", "stroom": 8.52455, "gas": 2.95666906}, {"datum": "21-10-2023", "stroom": 9.096604, "gas": 3.07442792}, {"datum": "22-10-2023", "stroom": 9.086367, "gas": 2.90511974}, {"datum": "23-10-2023", "stroom": 8.854802, "gas": 3.05840303}, {"datum": "24-10-2023", "stroom": 8.468058, "gas": 3.1672682}, {"datum": "25-10-2023", "stroom": 8.560278, "gas": 3.18810383}, {"datum": "26-10-2023", "stroom": 8.584232, "gas": 3.11528614}, {"datum": "27-10-2023", "stroom": 8.684978, "gas": 3.2798946}, {"datum": "28-10-2023", "stroom": 9.453217, "gas": 3.41381906}, {"datum": "29-10-2023", "stroom": 10.471784, "gas": 3.48598024}, {"datum": "30-10-2023", "stroom": 9.402728, "gas": 3.56958755}, {"datum": "31-10-2023", "stroom": 9.401597, "gas": 3.62275514}, {"datum": "1-11-2023", "stroom": 9.646096, "gas": 3.76247078}, {"datum": "2-11-2023", "stroom": 9.569797, "gas": 3.79335062}, {"datum": "3-11-2023", "stroom": 9.587922, "gas": 3.67880611}, {"datum": "4-11-2023", "stroom": 10.243293, "gas": 3.63490626}, {"datum": "5-11-2023", "stroom": 10.320897, "gas": 3.78758707}, {"datum": "6-11-2023", "stroom": 9.67933, "gas": 3.97212916}, {"datum": "7-11-2023", "stroom": 9.629682, "gas": 4.17706524}, {"datum": "8-11-2023", "stroom": 9.88349, "gas": 4.24792609}, {"datum": "9-11-2023", "stroom": 9.789588, "gas": 4.39175154}, {"datum": "10-11-2023", "stroom": 9.861653, "gas": 4.41613518}, {"datum": "11-11-2023", "stroom": 10.469841, "gas": 4.59637202}, {"datum": "12-11-2023", "stroom": 10.541239, "gas": 4.63698242}, {"datum": "13-11-2023", "stroom": 10.243699, "gas": 4.7195774}, {"datum": "14-11-2023", "stroom": 9.943868, "gas": 4.78600768}, {"datum": "15-11-2023", "stroom": 9.968721, "gas": 4.81466141}, {"datum": "16-11-2023", "stroom": 10.023995, "gas": 4.96622921}, {"datum": "17-11-2023", "stroom": 10.036958, "gas": 5.05569503}, {"datum": "18-11-2023", "stroom": 10.65808, "gas": 5.23945098}, {"datum": "19-11-2023", "stroom": 10.694127, "gas": 5.34327938}, {"datum": "20-11-2023", "stroom": 10.378491, "gas": 5.68601556}, {"datum": "21-11-2023", "stroom": 10.118564, "gas": 5.74850358}, {"datum": "22-11-2023", "stroom": 10.049747, "gas": 5.61756916}, {"datum": "23-11-2023", "stroom": 10.191905, "gas": 5.43609485}, {"datum": "24-11-2023", "stroom": 10.309007, "gas": 5.55160963}, {"datum": "25-11-2023", "stroom": 11.059527, "gas": 5.61753797}, {"datum": "26-11-2023", "stroom": 11.120137, "gas": 5.5794874}, {"datum": "27-11-2023", "stroom": 10.704857, "gas": 5.70469898}, {"datum": "28-11-2023", "stroom": 10.257068, "gas": 5.77639088}, {"datum": "29-11-2023", "stroom": 10.483674, "gas": 5.93504257}, {"datum": "30-11-2023", "stroom": 10.752272, "gas": 6.04070029}, {"datum": "1-12-2023", "stroom": 11.036646, "gas": 6.09285304}, {"datum": "2-12-2023", "stroom": 11.445082, "gas": 6.15886988}, {"datum": "3-12-2023", "stroom": 11.656811, "gas": 6.18658619}, {"datum": "4-12-2023", "stroom": 11.281957, "gas": 6.38676769}, {"datum": "5-12-2023", "stroom": 10.826454, "gas": 6.39470252}, {"datum": "6-12-2023", "stroom": 11.113902, "gas": 6.37163657}, {"datum": "7-12-2023", "stroom": 11.253595, "gas": 6.46708343}, {"datum": "8-12-2023", "stroom": 11.481912, "gas": 6.57854221}, {"datum": "9-12-2023", "stroom": 11.785281, "gas": 6.7170259}, {"datum": "10-12-2023", "stroom": 11.994342, "gas": 6.71854288}, {"datum": "11-12-2023", "stroom": 11.304954, "gas": 6.64992443}, {"datum": "12-12-2023", "stroom": 11.10178, "gas": 6.51386155}, {"datum": "13-12-2023", "stroom": 11.210878, "gas": 6.5689296}, {"datum": "14-12-2023", "stroom": 11.079653, "gas": 6.72261404}, {"datum": "15-12-2023", "stroom": 11.247969, "gas": 6.80619704}, {"datum": "16-12-2023", "stroom": 11.8697, "gas": 6.7838974}, {"datum": "17-12-2023", "stroom": 12.150942, "gas": 6.58253207}, {"datum": "18-12-2023", "stroom": 11.457755, "gas": 6.49862754}, {"datum": "19-12-2023", "stroom": 11.439601, "gas": 6.51519817}, {"datum": "20-12-2023", "stroom": 11.488553, "gas": 6.80140727}, {"datum": "21-12-2023", "stroom": 11.511898, "gas": 7.02736985}, {"datum": "22-12-2023", "stroom": 11.269458, "gas": 6.77435087}, {"datum": "23-12-2023", "stroom": 11.667715, "gas": 6.690633}, {"datum": "24-12-2023", "stroom": 12.176143, "gas": 6.4199535}, {"datum": "25-12-2023", "stroom": 12.185655, "gas": 6.63312469}, {"datum": "26-12-2023", "stroom": 12.185974, "gas": 6.89685004}, {"datum": "27-12-2023", "stroom": 11.798592, "gas": 7.14043776}, {"datum": "28-12-2023", "stroom": 11.880111, "gas": 7.24106764}, {"datum": "29-12-2023", "stroom": 11.375627, "gas": 7.19102346}, {"datum": "30-12-2023", "stroom": 11.427334, "gas": 7.14543568}, {"datum": "31-12-2023", "stroom": 10.623773, "gas": 6.88440509}]

# TODO: begindatum meenemen

def bereken(soort, input, output):
  factor = 1.0
  if soort == "warmte":
    soort = "gas"
    factor = (37/1200)

  verbruik = float(hass.states.get(input).state)
  cumul = 0
  datum = ""

  for v in dagtabel:
    cumul = cumul + v[soort]*factor
    #logger.info("cumul={}, verbruik={}, cumul>verbruik={}".format(cumul, verbruik, cumul>verbruik))
    if cumul >= verbruik:
      datum = v["datum"]
      break

  logger.info("soort is {}, cumul is {}, verbruik is {}, plafonddatum is {}".format(soort, cumul, verbruik, datum))

  #hass.states.set(output, time.strftime("%Y-%m-%d", time.strptime(datum, "%d-%m-%Y")))
  hass.services.call("input_datetime", "set_datetime", 
    {
      "date": time.strftime("%Y-%m-%d", time.strptime(datum, "%d-%m-%Y")), 
      "entity_id": output
    }
  )



bereken("stroom", "sensor.stroomverbruik_contractperiode", "input_datetime.stroomdatum_prijsplafond")
bereken("warmte", "sensor.warmteverbruik_contractperiode", "input_datetime.warmtedatum_prijsplafond")

configuration.yaml

template:
  - sensor:
    - name: Nettosaldo stroom
      unique_id: nettosaldo_stroom
      unit_of_measurement: kWh
      state: >
        {{ states("sensor.toon_p1_power_use_cnt_low") | float + states("sensor.toon_p1_power_use_cnt_high") | float -
           states("sensor.toon_p1_power_prod_cnt_low") | float - states("sensor.toon_p1_power_prod_cnt_high") | float }}
  - sensor:
    - name: stroomverbruik contractperiode
      unique_id: stroomverbruik_contractperiode
      unit_of_measurement: kWh
      state: >
        {{ states("sensor.nettosaldo_stroom") | float - states("input_number.nettosaldo_stroom_per_startdatum_contract") | float }}
  - sensor:
    - name: warmteverbruik contractperiode
      unique_id: warmteverbruik_contractperiode
      unit_of_measurement: GJ
      state: >
        {{ states("sensor.kamstrup_403_heat_energy_e1") | float - states("input_number.nettosaldo_warmte_per_startdatum_contract") | float }}

extra notes

# prijsplafond
# 2900 kWh/jaar
# 37 GJ/jaar
# 1200 kuub gas/jaar
# csv op https://www.rijksoverheid.nl/onderwerpen/koopkracht/documenten/publicaties/2023/01/17/hoeveelheden-gas-en-stroom-tegen-de-tarieven-van-het-prijsplafond-per-dag
# json via ( echo "datum;stroom;gas" ; tail -n +2 Hoeveelheden+gas+en+stroom+onder+prijsplafond+per+dag.csv | sed s/,/./g ) | csvjson -d ';' | jq .

'dagtabel' komt uit regel 6 van deze note