AnsweredAssumed Answered

PITimeFilterVal()

Question asked by CPhilips on Feb 26, 2017
Latest reply on Feb 27, 2017 by CPhilips

Hi Everyone,

 

Please forgive my ignorance I'm a complete noob with Pi Datalink.

 

I've been trying to get the PITimeFilterVal() function to work without much success.

The particular case I'm using it for is I have a fleet of 36 machines that I want to know how many hours each of them runs for each of the 28 day periods in the last 2 years. I've set up an excel spread sheet as shown in the attached picture, which is meant to summate the hours for each machine where the motor amps are greater than 40 (the running condition). The results seem to be OK for the first 3 rows but after that I get results that are impossible (greater than 672, which is the total hours in 28 days (bad data in red)). It appears that the function gets confused when the formula is dragged down. I also tried to manually input the formula with the same results. Interestingly after the third or fourth row of data the formula seems to ignore the zero for the outcode as it tries to drop additional data into adjacent cells.

 

If anyone can help me out I'd appreciate it.

 

Thanks

 

Cameron

 

PITimeFilterVal2.jpg

Outcomes