ATULP Calculates the average tank usage (i.e. chemical usage) between the current value and the previous 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:
ATULP(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.
Before Fill and After Fill entries MUST be made in the same data slot as the tank level in order for the tank usage to be calculated correctly. Before Fill and After Fill entries made between Tank Level Entries are ignored and will cause bad results.
SEE ALSO:
ATUFN, ATUFP, ATULN, TUFN, TUFP, TULN, TULP
EXAMPLES:
V8009 =ATULP(C8005,C8006,C8007)
V8019 = ATULP(C8015,C8016,C8017) 'calculate hourly usage from hourly variables
