ATULN Calculates the average tank usage (i.e. chemical usage) between the current value and the next entered value. When the tank is refilled, this function assumes it is filled back to a level. Calculates a value in for every day.
SYNTAX:
ATULN(TankLevelVar,BeforeFillVar, AfterFillVar)
where :
TankLevelVar is a conditional variable x that refers to the level of the tank
BeforeFillVar is a conditional variable x that refers to the level of the tank before it is filled
AfterFillVar is a conditional variable x that refers to the level of the tank after it 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:
ATUFN, ATUFP, ATULP, TUFN, TUFP, TULN, TULP
EXAMPLES:
V8009 =ATULN(C8005,C8006,C8007)
ATULN(C8015,C8016,C8017) - Get Average Tank Usage using hourly variables.
