Usage

you can query time series data in excel using custom functions provided by the excel add in after setting up a connection in the configuration screen, these functions work just like excel’s built in ones when you type = , a dropdown shows all available functions those starting with factry come from the add in below, we demonstrate two of these functions you can find details about all functions in the help section, accessible through the task pane’s help button have a look at the excel add in docid\ tzcjzg8r2lbq b2ikbzob for a complete overview of all available functions example for getting a single value of a measurement select any cell in the worksheet and type in the following formula =factry get val(“historian”;“plant1”;“machine1/temperature”; now();“1h”) replace “historian” with the name of the connection you have configured here replace “plant1” with the name of the time series database of the measurement replace “machine1/temperature” with the name of the measurement you whish to query replace now() with the specific timestamp to query or keep it to get the most recent value replace “1h” with the maximum age that the value may have pressing enter will display the resulting value in the selected cell example for getting multiple raw values select any cell in the worksheet and type in the following formula =factry get raw data(“historian”;“plant1”;{“calc const bool”;“calc const number”};now() 1;now() 1;10) replace “historian” with the name of the connection you have configured here replace “plant1” with the name of the time series database of the measurement replace {“calc const bool”;“calc const number”} with an array the measurement you whish to query you can also use a single measurement replace now() 1 with the start time and now() with the end time replace 10 with the maximum number of values you want returned pressing enter will display the resulting value in the cells below the formula