All,
I'm quite new to SEEQ, so bear with me. I'm trying to build out a workbench to reflect daily raw material usage out of a small tank. I would like to calculate the daily usage amount by taking the ending - starting tank levels. I have a formula to convert our storage tank level % into total mass (kgs). As you imagine, the calculation is quite easy whenever no new drums are added to the tank.
The problem arises when I have days they add new material to the tank (typically every 3-4 days). Since the new raw material is added via full 55 gal drums, I would rather calculate this additional volume at # of drums x "standard wt./drum" (versus direct tank level increase). I want to be able to capture any heels left in the 55 gal drums as "usage" for that day. Each drum increases the tank level by ~21%, so it should be pretty easily to identify and calculate # of drums and the corresponding total wt. Nearly every time the tank is filled, x2 drums are pumped into storage tank back-to-back, but there can be time either only 1 or as many as 3 drums are pumped in.
Once I can identify these x2 conditions, the daily usage should be "EndTankVolume" - "StartTankVolume" - "#DrumsOffloaded"x"321kg/drum".
Any help would be much appreciated.
