ATUFN 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 with an amount. Calculates a value in for every day.
SYNTAX:
ATUFN(TankLevelVar,BeforeFillVar, FillAmountVar)
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
FillAmountVar is a conditional variable x that refers to amount added to the tank.
NOTES:
This function will only search forward and backward 183 days (6 months) from the day it is attempting to calculate.
SEE ALSO:
ATUFP, ATULN, ATULP, TUFN, TUFP, TULN, TULP
EXAMPLES:
V8009 =ATUFN(C8005,C8006,C8007)
V8019 = ATUFN(C8015,C8016,C8017) ' Average Tank Usage based on hourly vars:
