Hello Ben,
Great, thank you all for your help. Yes it is a problem with timezone adjustments. I will solve that later. First of all I shifted the timeframe of the reference data one hour into the future. After a lot of slicing and pasting (3 weekly time frames times 4 seasonal time frames times 3 utility models (household, company, band)) I could (almost) resolve my standard load profile for power consumption for households without using R. There are minor problems with the boundaries but I will solve that later. In my screenshot you can see the R-solution (top) and the Seeq-solution (bottom). Great thing because now I don't need to recalculate the prediction of power consumption with R and store it into PI. Instead of that I can calculate the model in real time and into the future with Seeq. There is just one big need. I need an additional function "holiday" in your "Periodic Condition" tool (I know that's not that easy but there are similar tools in Python and R too). See in my R-example (top) Christmas day should be a "Sunday" behavior.