Excel Add-in

the factry historian excel add in enables you to retrieve time series data from factry historian (from measurements docid\ xqwlemdcnfff3 0h gmms and calculations docid\ opiodkgnngyjedx6zkg d ) into microsoft excel directly before you can use the add in, you will need to installation docid\ thr5adnflww ercfy68qn and configuration docid\ y6tuqfjplisssz44wjm8h to a factry historian instance once installed and configured, the following functions become available these functions are prefixed with factry , e g \=factry get val(arguments ) =factry get sampled data mean(arguments ) single value functions these functions return a single value to the cell where the formula is entered get val description returns the value of the most recent datapoint before a given timestamp arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurement description the measurement to query datatype text example js opc ua name timestamp description the latest timestamp allowed for the datapoint (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name \[maxage] description the maximum age of the datapoint relative to the timestamp accepts hours, minutes, and seconds datatype text example 48h | 1h30m | 1m30s get calc val count description returns the number of datapoints between a start and end time arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurement description the measurement to query datatype text example js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 get calc val integral description returns the integral of the values between the start and end time in steps of a base period arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurement description the measurement to query datatype text example js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name baseperiod description the unit of time to integrate over accepts hours, minutes, and seconds datatype text example 1h30m get calc val mean description returns the mean value between the start and end time arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurement description the measurement to query datatype text example js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 get calc val median description returns the median value between the start and end time arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurement description the measurement to query datatype text example js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 get calc val mode description returns the mode of the values between the start and end time arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurement description the measurement to query datatype text example js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 get calc val spread description returns the spread (difference between max and min) of the values between the start and end time arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurement description the measurement to query datatype text example js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 get calc val stddev description returns the standard deviation of the values between the start and end time arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurement description the measurement to query datatype text example js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 get calc val sum description returns the sum of the values between the start and end time arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurement description the measurement to query datatype text example js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 get calc val first description returns the first value between the start and end time arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurement description the measurement to query datatype text example js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 get calc val last description returns the last value between the start and end time arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurement description the measurement to query datatype text example js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 get calc val max description returns the maximum value between the start and end time arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurement description the measurement to query datatype text example js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 get calc val min description returns the minimum value between the start and end time arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurement description the measurement to query datatype text example js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 multiple value functions these functions return multiple values in a range of cells the first column contains timestamps, formatted by default as dd/mm/yy hh\ mm\ ss to change the format, apply a custom excel cell format get raw data description returns timestamp–value pairs for all specified measurements between a start and end time arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurements description the measurements to query datatype excel range | text example a3\ b4 | js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name limit description the maximum number of datapoints for each measurement use 0 for no limit datatype number example 10 get sampled data count description returns the number of datapoints for each measurement in every sampling interval between start and end time arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurements description the measurements to query datatype excel range | text example a3\ b4 | js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name samplinginterval description the time interval for each sample accepts hours, minutes, and seconds datatype text example 1h30m name limit description the maximum number of datapoints for each measurement use 0 for no limit datatype number example 10 name \[fill] description the type of fill used options none, null, previous, linear, 0 default is null datatype text example linear get sampled data integral description returns the integral over values in steps of a base period for all measurements in each sampling interval arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurements description the measurements to query datatype excel range | text example a3\ b4 | js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name samplinginterval description the time interval for each sample accepts hours, minutes, and seconds datatype text example 1h30m name limit description the maximum number of datapoints for each measurement use 0 for no limit datatype number example 10 name baseperiod description the unit of time to integrate over accepts hours, minutes, and seconds datatype text example 1h30m name \[fill] description the type of fill used options none, null, previous, linear, 0 default is null datatype text example linear get sampled data mean description returns the mean value for all measurements in each sampling interval arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurements description the measurements to query datatype excel range | text example a3\ b4 | js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name samplinginterval description the time interval for each sample accepts hours, minutes, and seconds datatype text example 1h30m name limit description the maximum number of datapoints for each measurement use 0 for no limit datatype number example 10 name \[fill] description the type of fill used options none, null, previous, linear, 0 default is null datatype text example linear get sampled data median description returns the median value for all measurements in each sampling interval arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurements description the measurements to query datatype excel range | text example a3\ b4 | js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name samplinginterval description the time interval for each sample accepts hours, minutes, and seconds datatype text example 1h30m name limit description the maximum number of datapoints for each measurement use 0 for no limit datatype number example 10 name \[fill] description the type of fill used options none, null, previous, linear, 0 default is null datatype text example linear get sampled data mode description returns the mode for all measurements in each sampling interval arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurements description the measurements to query datatype excel range | text example a3\ b4 | js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name samplinginterval description the time interval for each sample accepts hours, minutes, and seconds datatype text example 1h30m name limit description the maximum number of datapoints for each measurement use 0 for no limit datatype number example 10 name \[fill] description the type of fill used options none, null, previous, linear, 0 default is null datatype text example linear get sampled data spread description returns the spread of values for all measurements in each sampling interval arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurements description the measurements to query datatype excel range | text example a3\ b4 | js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name samplinginterval description the time interval for each sample accepts hours, minutes, and seconds datatype text example 1h30m name limit description the maximum number of datapoints for each measurement use 0 for no limit datatype number example 10 name \[fill] description the type of fill used options none, null, previous, linear, 0 default is null datatype text example linear get sampled data stddev description returns the standard deviation of values for all measurements in each sampling interval arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurements description the measurements to query datatype excel range | text example a3\ b4 | js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name samplinginterval description the time interval for each sample accepts hours, minutes, and seconds datatype text example 1h30m name limit description the maximum number of datapoints for each measurement use 0 for no limit datatype number example 10 name \[fill] description the type of fill used options none, null, previous, linear, 0 default is null datatype text example linear get sampled data sum description returns the sum of values for all measurements in each sampling interval arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurements description the measurements to query datatype excel range | text example a3\ b4 | js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name samplinginterval description the time interval for each sample accepts hours, minutes, and seconds datatype text example 1h30m name limit description the maximum number of datapoints for each measurement use 0 for no limit datatype number example 10 name \[fill] description the type of fill used options none, null, previous, linear, 0 default is null datatype text example linear get sampled data first description returns the first value for all measurements in each sampling interval arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurements description the measurements to query datatype excel range | text example a3\ b4 | js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name samplinginterval description the time interval for each sample accepts hours, minutes, and seconds datatype text example 1h30m name limit description the maximum number of datapoints for each measurement use 0 for no limit datatype number example 10 name \[fill] description the type of fill used options none, null, previous, linear, 0 default is null datatype text example linear get sampled data last description returns the last value for all measurements in each sampling interval arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurements description the measurements to query datatype excel range | text example a3\ b4 | js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name samplinginterval description the time interval for each sample accepts hours, minutes, and seconds datatype text example 1h30m name limit description the maximum number of datapoints for each measurement use 0 for no limit datatype number example 10 name \[fill] description the type of fill used options none, null, previous, linear, 0 default is null datatype text example linear get sampled data max description returns the maximum value for all measurements in each sampling interval arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurements description the measurements to query datatype excel range | text example a3\ b4 | js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name samplinginterval description the time interval for each sample accepts hours, minutes, and seconds datatype text example 1h30m name limit description the maximum number of datapoints for each measurement use 0 for no limit datatype number example 10 name \[fill] description the type of fill used options none, null, previous, linear, 0 default is null datatype text example linear get sampled data min description returns the minimum value for all measurements in each sampling interval arguments name connection description the connection name configured in the excel add in taskpane datatype text example factry name database description the database name datatype text example historian name measurements description the measurements to query datatype excel range | text example a3\ b4 | js opc ua name start description the start time of the query (inclusive) datatype excel datetime example 28/06/2022 16 20 00 name end description the end time of the query (exclusive) datatype excel datetime example 29/06/2022 16 20 00 name samplinginterval description the time interval for each sample accepts hours, minutes, and seconds datatype text example 1h30m name limit description the maximum number of datapoints for each measurement use 0 for no limit datatype number example 10 name \[fill] description the type of fill used options none, null, previous, linear, 0 default is null datatype text example linear