ETUP Calculates the average tank usage (i.e. chemical usage) between the previous and current value. When the tank is refilled, this function averages the last x days drops to estimate the usage on that day.
SYNTAX:
ETUP(TankLevelVar,MovingAvgDaysOnFill)
where :
TankLevelVar is a conditional variable x that refers to the level of the tank
MovingAvgDaysOnFill a constant that sets the number of days to average the drops on days where tank is filled.
NOTES: This function will only search forward and backward 183 days (6 months) from the day it is attempting to calculate.
SEE ALSO: ETUN, ATUFP, ATULN, ATULP, TUFN, TUFP, TULN, TULP
EXAMPLES
V11262 =ETUP(C11259,7)