Home : ATULN
Q14313 - INFO: ATULN
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.

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 5/4/2015 3:15 PM.
Last Modified on 5/8/2015 8:34 AM.
Last Modified by Scott Dorner.
Article has been viewed 3854 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article