Example of Calculation Syntax

The MCE format to define an ItemName is completely different to the legacy IPMS but essentially the MCE format takes the format [CompanyName|SiteName|MeterName|CALC].XXXX where XXX is the command. The MCE format for Date and Time uses the principle of Ticks where a single Tick represents one ten millionth of a second. There are 10,000 ticks in a millisecond.

This list is not exhaustive in any way and ther are plenty of additional MCE functions that have not been included.

Function	Description	Example
period(dataItemName)	Returns the aggregation period of the meter in ticks	period(12345)
Time	Returns the value of the date in ticks but Item MUST have an Start and End Time associated with it otherwise the data will not be calculated	Time
Index	Returns the Index of the value in the database with the first reading in the database having a value of 0. Very useful for initiating counts that are to be used with the .GetValue command but Item MUST have an Start and End Time associated with it otherwise the data will not be calculated	Index
Index-value	Returns the Index of the value in the database with the first reading in the database having a value of 0 less the value shown. Very useful for initiating counts that are to be used with the .GetValue command but Item MUST have an Start and End Time associated with it otherwise the data will not be calculated	Index-30
MCEdataItemName .Last.Value	Gets the last value for the Item in the database	[Meniscus|Brewery|Inlet flow|Calc].Last.Value
MCEdataItemName .EndTime	Gets the last time for the meter in the database in ticks	[Meniscus|Brewery|Inlet flow|Calc].EndTime
MCEdataItemName .Count	Counts the total number of points in the database	[Meniscus|Brewery|Inlet flow|Calc].Count
(MCEdataItemName .Count) – Index	Counts total number of readings and then subtracts the index from this. Creates a declining index counting to 1 at the most recent value in the database	([Meniscus|Brewery|Inlet flow|Calc].Count)-Index
choose(Index < MCEdataItemName .Count-30 ,0,1)	If the current Index of the Item < than the total number of points in the Item -30 then 0 else 1	choose(Index < [Meniscus|Brewery|Inlet flow|Calc].Count-30,0,1)
MCEdataItemName .GetValueAtTime( Time)	This acts in the same way as the IPMS format data(12345,today) and is the MCE syntax version of this. Except it interpolates between readings if the aggregation period is different	[Meniscus|Brewery|Inlet flow|Calc] .GetValueAtTime(Time)
MCEdataItemName .GetValueAtTime( dateserial( yyyy,mm,dd))	Gets the value at the date specified in the dateserial expression	Meniscus|Brewery|Inlet flow|Calc] .GetValueAtTime( dateserial(2010,03,25))
MCEdataItemName .GetValueAtTime( dateserial(new DateTime (today).Year, month(today), day(today))	Gets the value of the MCE DataItem at the day, month and year of the calculation as it is processed. Useful for taking a value for a daily aggregated data item and passing to, say, an hourly aggregated DataItem. There is currently no year(today) syntax and the new DateTime(today).Year is the c# equivalent to achieve this	MCEdataItemName .GetValueAtTime( dateserial(new DateTime(today).Year, month(today),day(today)))
MCEdataItemName .GetValueAtTime.(DateTime.Now .Ticks)	Gets the value for just today’s exact date and time. Will interpolate between points on a linear basis if no exact point is found	[Meniscus|Brewery|Inlet flow|Calc] .GetValueAtTime.(DateTime.Now.Ticks)
MCEdataItemName .GetValueAtTime( dateserial( DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day))	Gets the value for the Item using today’s actual Year, Month and Day values. If we use Now.Year-1 this would use data for Last year, Month-1 would be last month etc.	Meniscus|Brewery|Inlet flow|Calc].GetValueAtTime( dateserial(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day))
MCEdataItemName1 .GetItem( MCEdataItemName2 .Count-1).Value	Gets the last value from Item1 using the counter in Item2	[Meniscus|Brewery|Inlet flow|Calc].GetItem( [Meniscus|Brewery|Inlet flow|Calc].Count-1).Value
MCEdataItemName1 .GetItem( MCEdataItemName2 .Count-30).Value	Gets the value from Item1 using the counter in Item2 less 30	[Meniscus|Brewery|Inlet flow|Calc].GetItem( [Meniscus|Brewery|Inlet flow|Calc].Count-30).Value
MCEdataItemName1 .GetItem( (int)data(meterid2, today) +offset).Value	Gets the value from a Itemcalled Itemid2 and adds an offset of 48. This value is then used to get the value from the RawData of MCEDataItemName1. This is creating a calculated offset from a rawdata list. Can feed in the offset from a Lookup and the use this method to get the rawdata values	[Profile|RAW].GetItem( (int)data(counter,today-period(counter)*1)+48).Value
counter( [MCEdataItemName| CALC] .GetItem( Index).Time, true/false, period	Creates a counter that counts forward if the boolean value is set to true and counts backwards if set to false. Counts forward the number of aggregation periods defined in the period element.