Home : Products : Hach WIMS : Hach WIMS Client : Documentation : Function Reference : Math Toolbox Functions : ADFN
Q10522 - INFO: ADFN

ADFN calculates the average difference between the current value and the next entered value. Puts a value in for every day. 

SYNTAX:

ADFN(Cx, Optional Rollover)

where :
Cx is a conditional variable x
Rollover is an optional parameter that specifies the Rollover Point.

NOTES:

If the optional Rollover  parameter is not specified, the system assumes the rollover point is at the next power of 10.

This function will only search forward and backward 183 days (6 months) from the day it is attempting to calculate.

EXAMPLES:

Example 1:

V10 = ADFN(C9)   V12 = ADFN(C11,10000)

Example 2:

V100004 = ADFN(V100003)

In this example we demonstrate the result of the function only searching 183 days back and 183 days forward for values (within a 366 day "view" of the data).  In the data below, the first screen capture is from January of 2005.  The second screen capture is from July of the same year.  Our data points (January 1, 2005 and July 9, 2005) are exactly 190 days appart.  The ADFN function starts calculating the average difference on the first day that it can find 2 values to compare: looking forward 183 days and backward 183 days.  That day is January 7th, which is 183 days away from July 9th.  It then inserts the average difference (in this case 1) in every day from that day forward; however, it will not insert that data looking backward.  Therefore, January 2nd through the 6th are left blank:

See Also: ADIF

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 10/9/2007 10:38 AM.
Last Modified on 2/14/2011 12:04 PM.
Last Modified by Scott Dorner.
Article has been viewed 6130 times.
Rated 8 out of 10 based on 6 votes.
Print Article
Email Article