DOR Daily Calculation Methodology

When the daily calculate EXE fires, it gets what items to calculate by

SELECT     Pid.*
FROM         dbo.tblPLC_PLCid AS Pid 
WHERE     (Pid.TrackDataOnceDaily = 1) 
    AND (LEFT(ISNULL(Pid.PLC_SubTagName, ' '), 1) = '=')
    AND Pid.DisplayItNow=1

It will forcibly calculate all daily items that have a formula beginning with =

When calculating, if any of the PLCid components of a formula are disabled, IE: DisplayItNow=False, they will be replaced with 0.0

Logic prior to 3/20/2023

Find all datapoints that are from external datasources or manual entries and calculate their dependents, whether disabled or not.

Plant Focus Knowledge Base

DOR Daily Calculation Methodology

Analytics

Logic prior to 3/20/2023

Related content