Purpose

A new widget focused on the Sudden Loss Alarm providing a visualisation of the relationship between sales and the inventory drop. ATG deliveries have been included to assist with identifying if there is excessive float movement associated with deliveries, and Inventory volume has been included to pinpoint if an issue exists in a specific area of a tank. Combines information from the current Sudden Loss (Raw Data) and the Sudden Loss Sales for Hour (comparison of initial vs current sales volume and count) reports.

Key Features

Bar Chart:

• Initial Sales: the raw sales which were originally received
• Current Sales: the raw sales AND any additional late sales which have been processed
• Inventory Drop: the volume change between the open and close inventory, with deliveries excluded
• ATG Dels: the calculated delivery volume

Line Chart:

• Inventory: the inventory close for the date/time

Views:

• Switch on the Sudden Loss toggle to see any Sudden Loss events
• Change to hourly data (max 3 days) and change the date range via the date selector (max 31 days)
• The default is daily data so the user can quickly and easily see if there have been any recent Sudden Loss events, with the option to select hourly data to ‘zoom in’
• Hover over trends for more detail
• Click on the bottom key to turn Initial Sales, Current Sales, Inv Drop, Inventory and/or ATG Dels on/off

Sudden Loss Event: A triangle is placed at the alarm event start time along the X-axis as a visual indicator of the Sudden Loss Alarm Status:

• Alarm occurred – triangle is red
• Acknowledged – triangle is orange
• Alarm cleared – triangle is grey

Slide out panel: Click into graph and expand for detailed data.

Logic

Inventory Drop: The volume change between the opening and closing inventory, excluding deliveries. 

• This value should theoretically approximate the Initial Sales value. 
• Any discrepancy requires further investigation to determine if it is due to late or missing sales, probe fluctuations, leaks, or other issues.

Delta Sales Count: The difference between the current and initial sales count.

• If the value is not zero, it will be highlighted in red.
• A non-zero delta suggests that late sales may be a contributing factor to a Sudden Loss alarm.

Calculated Inventory: The 'bookstock' or 'theoretical' closing inventory based on the Initial Sales value.

Loss: The variance between Inventory Close and Calculated Inventory (based on initial sales), as well as the difference between Initial Sales and Inventory Drop. 

• A correlation between this figure and the discrepancy between Initial and Current Sales volumes suggests late sales may be a factor. 
• A lack of discrepancy could indicate a leak or other issue.

Water: The water level at Inventory Close. 

• Water ingress may also be an indicator of a possible leak.

Examples:

Probe Fluctuation

Sudden Loss Alarm from Active Alarms Widget

Sales vs Inventory Widget - Daily

Sales vs Inventory Widget - Hourly