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