it is my first post here, so I don't know where I should exactly post it. First of all, I will explain my problem and then I will ask you some questions concerning it.
I have to analyze a steelplant consisting of 2 electric arc furnaces and 2 ladle furnaces, so there is a huge amount of energy consumption. There exists a time limit from the energyprovider, where the consumption is limited to some MWh. So they always observe 15 minutes (eg: 15:00-15:15,15:15-15:30 and so on) and if the plant exceeds the MWh-Limit, the energy is shut off. But there are still processes running on (melting, heating and so on). So the steelplant wants to know, if a shutoff is coming and if so, they want an alarm/warning so they can react (turn down the furnaces enough to keep them running).
So my problem is how (to get the Data into Knime and) analyse it correctly. I got a log-file with +600k lines where I can extract the data from. The data is not exactly following hh:mm:ss. Sometimes I have a signal every second, sometimes I have two signals for the same second, sometimes there is a signal every 3-10 seconds and if an aggregate is turned of, there is no new signal for 0-120minutes.
The difficulty is, that there are 4 separate aggregates and their power on time and energy consumption differs a lot and is quite variable and so I thought it would be good to watch a whole day, then maybe 6 hours down to the 15 minutes. And maybe it is possible to predict the energyconsumption during such a 15 minutes interval, so let's say we have minute 8 of 15 and from there on I want be able to say if there is a shutdown or not.
So, maybe one has a tip for a correct workflow. First of all, I read the data, then I filtere and extract some necessary data, but I don't know how to exactly combine them to get the info I want.
PS: If you need further Info, let me know