...
| Short-Code | Valid Datatypes | Description |
|---|---|---|
| # | All | If a number is a zero but the formula is followed by the # symbolt it will be replaced with a 1 instead. |
| a | Once A Day, RealTime, Once A Month, Once a Shift, Optimization, LAB | Average of all values including zeros. |
| A | Once A Day, RealTime, Once A Month, Once a Shift | The time weighted average of all datapoints for the day (including zeros) |
| b | Once A Day, RealTime, Once A Month, Once a Shift, Optimization, LAB | Average of all values excluding zeros. |
| B | Once A Day, RealTime, Once A Month, Once a Shift | The time weighted average of all datapoints for the day excluding zeros) |
| c | Once A Day, RealTime, Once A Month, Once a Shift | Calculated value instead of raw value (including adjustment) |
| d | RealTime | The difference between the 2 most recent datapoints. |
| e | Once A Day, RealTime | Duration of time from NOW to the end of the selected timeframe or shift. |
| f | Once A Day, RealTime, Once A Month, Once a Shift | Performs the statistical function (STDEV, MIN, MAX) that appears after f and before the PLCid. Example, fSTDEV6120 is the Standard Deviation of DOR Item 6120, including zeroes. |
| F | Once A Day, RealTime, Once A Month, Once a Shift | Performs the statistical function (STDEV, MIN, MAX) that appears after F and before the PLCid. Example, FSTDEV6120 is the Standard Deviation of DOR Item 6120, NOT including zeroes. |
| i | Once A Day | Most recent inventory running total (including adjustment) |
| k | RealTime, Once a Shift | The very last datapoint of the previous day, based on the start date selected. |
| l | Once A Day, RealTime, Once a Shift | Last value present prior to end date, regardless of start date. Only raw value will be returned, or only adjustment, if present, will be returned. |
| L | RealTime, Once a Shift | The next to last datapoint of the timeframe specified based on the start and end dates selected. If no data is present within these times then no data will be returned |
| m | Once A Day, RealTime, Once A Month, Once a Shift, Optimization, LAB, Silo Inventory | Most recent value present prior to end date. Inclusive of data on the end date. Includes adjustments. |
| M | RealTime, Once a Shift | The value directly before the most recent value prior to the end date (independent of start time). If used to reference a daily datapoint it will include the adjustment. |
| n | Once A Day, Once A Month, Once a Shift | Sum of values, does not include adjustments. |
| o | Once A Day, Once A Month, Once a Shift | Offset or adjustment value only. |
| p | Once A Day, RealTime, Once A Month, Once a Shift, Optimization, LAB, Downtime, Silo Inventory | Current day's value (including adjustment) |
| q | Once A Day, RealTime, Once A Month, Once a Shift, Optimization, LAB | Previous day's value. (On DOR report, cannot be a manual entry) |
| r | Once A Day | Reference value only valid on DOR admin for automated data gathering, NOT reporting, will return 0 otherwise. Valid for IP21 only. |
| R | Once A Day, RealTime, Once A Month, Once a Shift, Recipe | ComponentID of the recipe system. |
| s | Once A Day, RealTime, Once A Month, Once a Shift | The sum of InputID from shift comments |
| S | Once A Day, RealTime, Once A Month, Once a Shift | The average of InputID from shift comments |
| t | Once A Day, RealTime, Once a Shift | Duration of time from selected start date to end date. If selected end date is now then it will be the duration of time from start to now in minutes. |
| T | Once A Day, RealTime, Once a Shift | Duration of time from selected start date to end date. If selected end date is now then it will be the duration of time from start to end date. |
| u | Once A Day, RealTime, Downtime | Duration of time equipment was operating between start date and end date. If the selected end date is now it will be the duration of selected start date to now. |
| U | Once A Day, RealTime, Downtime | Duration of time equipment was NOT operating between start and end date. If selected end date is now it will be the duration of selected start date to now. |
| v | RealTime | Duration of time from the very last datapoint present in that items item's data to now in seconds |
| V | RealTime | Duration of time from the very last datapoint present in that items item's data to the preceding data point in seconds |
| z | Once A Day, RealTime, Once A Month | The average of all datapoints for the day excluding zeros |
| Z | Once A Day, RealTime, Once A Month | The time weighted average of all datapoints for the day excluding zeros. |
| dow | Date Labels | Returns the day of the week of the start date given DOW for date returns 'Monday' or 'Tuesday' |
| DOW | Date Labels | Returns the day of the week of the start date given dow for date returns 'Monday' or 'Tuesday' |
| date | Date Labels | This will return the text representing the end date (MM/dd/yyyy) |
| DATE | Date Labels | This will return the text representing the start date (MM/dd/yyyy) |
| datetime | Date Labels | Returns the text representing the end date (MM/dd/yyyy HH:mm) |
| DATETIME | Date Labels | Returns the text representing the start date (MM/dd/yyyy HH:mm) |
| DATEFORMAT,HH:mm | Date Labels | Returns the start date formatted the way you specify after the comma |
| dateformat,MM/dd/yyyy HH:mm | Date Labels | Returns the end date formatted the way you specify after the comma |
| NOW | Date Labels | Returns the current date time of the site in localized time format |
| NOW,HH:mm | Date Labels | Returns the current time of the site formatted the way you specify after the comma. |
...