I have 2 boolean tags which act as pointers to sort my data log into 2 sections every 24 hours; GGBS & OPC.
When GGBS boolean tags goes high, my data should log into table A & when OPC boolean tag goes high, same data should log into table B. These separate logs will then populate my Report excelsheet in 2 separate columns. The excelsheet representation will look like this for 24-hour period:-
Basically, my aim is to sort data logged for 24-hour period into 2 columns; i.e. if a particular process tag runs for 19hrs in GGBS & 5 hrs in OPC, it should correspondingly populate the 19 hour data into GGBS column & 5 hour data into OPC column for that particular process tag. I desire to achieve it in the software itself so that Reporting becomes easier & simpler to extrapolate.