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.