Zum Hauptinhalt wechseln

Time Series Clustering Toolbox

Andrii Zakovorotnyi

Groups similar intervals of time series or range columns or rows

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:

  • gathering required data by prompting a user to fill specific information into the Add-in dialog box - provide a reference to a range of values on an Excel worksheet, provide a number of clusters, choose what type of output information should be displayed by postprocessing;
  • data preprocessing - checking the non-numerical numbers in a referenced range, filling gaps using linear interpolation between known data points;
  • clustering of the data using the k-means algorithm;
  • data postprocessing - providing information general and detailed information about the results of the clustering procedure.

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.

Add-In-Funktionen
Hinweise für die Verwendung dieses Add-Ins:
  • Es kann Ihr Dokument lesen und Änderungen vornehmen.
  • Es kann Daten über das Internet senden.
  • https://store-images.s-microsoft.com/image/apps.33982.05c59682-0afd-4357-8a18-9de0b223651b.ce8f15b6-b44d-4106-ad75-e3dc5ccb29f0.48ba2154-9339-43f4-8a4c-8f59debc13e1.png
    https://store-images.s-microsoft.com/image/apps.33982.05c59682-0afd-4357-8a18-9de0b223651b.ce8f15b6-b44d-4106-ad75-e3dc5ccb29f0.48ba2154-9339-43f4-8a4c-8f59debc13e1.png
    https://store-images.s-microsoft.com/image/apps.32020.05c59682-0afd-4357-8a18-9de0b223651b.ce8f15b6-b44d-4106-ad75-e3dc5ccb29f0.8ba0ca41-b920-46bf-bbc3-e80a7ca71567.png
    https://store-images.s-microsoft.com/image/apps.59125.05c59682-0afd-4357-8a18-9de0b223651b.ce8f15b6-b44d-4106-ad75-e3dc5ccb29f0.1b0f3da8-5c96-42f4-a903-5e7a03f547f2.png
    https://store-images.s-microsoft.com/image/apps.29843.05c59682-0afd-4357-8a18-9de0b223651b.ce8f15b6-b44d-4106-ad75-e3dc5ccb29f0.67c0e6ad-660d-4eab-88d4-3e6f10640190.png
    https://store-images.s-microsoft.com/image/apps.21258.05c59682-0afd-4357-8a18-9de0b223651b.ce8f15b6-b44d-4106-ad75-e3dc5ccb29f0.13dfecf4-4a2c-45ab-bf69-eeac271b2f67.png