This Excel Web Add-in aims to assist users with their data analytics by completing a cluster analysis - the algorithm finds similar vectors in a selected Excel range on a user's worksheet, combines them into groups and present these groups using a new worksheet with additional information. The main advantage of this Add-in concerns the fact that it can work not only with Excel rows or columns but also with the time series and its timestamps - automatically splitting a time series into vectors using a predefined time interval. Add-in works with the following time intervals: seconds, minutes, hours and days.
The whole Add-in workflow can be divided into three steps:
This Excel Web Add-in will not send data from user's workbook using the internet connection. All calculations are fulfilled using the user's local computer or tablet.
The free version of this Office Add-in clusters only limited number of intervals, while the paid and trial versions of this Office Add-in cluster the unlimited number of intervals.
Note: in order to run this Office Add-in, a user needs to be signed in using your Microsoft Account and have a valid license.