formerpigeek

Calculating averages

Discussion created by formerpigeek on Jul 17, 2009
Latest reply on Jul 20, 2009 by andreas

Hi,

 

I am trying to calculate average, minimum and maximum values of a particular tags for a given start and end time in excel.

 

I am able to do it through PICompDat function which can list all the values for a specific period of time. But that is very ugly process.

 

I have to eliminate "#N/A" and "No more values:" messages in the column in every single cell for excel to be able to calculate the averages or the maximums which takes time.

 

Provided I am not missing any tag attribute given in the datalink,

 

Is there any faster way to get those values?

 

Please reply

 

Kapil.

Outcomes