 # Time Series Clustering Toolbox - Excel Web Add-In

## Input data

• ##### "Inputs are two vectors of timestamps and values" is specially designed to cluster time series. In this case, a user will be prompted to set references to a non-empty range with values, a non-empty range with timestamps and provide time interval. Add-In will split this referenced range with values according to timestamp range and given time interval, and further group this split vectors. ## Input data is a "2-dimensional range"

### Step 2

##### On this step, a user is prompted to set a number of clusters and (optional, only if exists) set a reference to a range with interval names. The number of clusters should be greater than 2 and lower than a number of columns (rows) of the range given in "Step 1". If the toggle "Fixed Value" is set to "No", then the clustering procedure will find an optimal number of clusters in a range from 2 to the given value in field "Number of Clusters"; if the toggle is set to "Yes", then the clustering procedure will try to find exactly given number of clusters in input range.    ## Inputs are two vectors of timestamps and values

### Step 2

##### On this step, a user is prompted to set a reference to a range with values and set a number of clusters. The number of clusters should be greater than 2. Range with values should have the same length as referenced in "Step 1" range with timestamps. If the toggle "Fixed Value" is set to "No", then the clustering procedure will find an optimal number of clusters in a range from 2 to the given value in field "Number of Clusters"; if the toggle is set to "Yes", then the clustering procedure will try to find exactly given number of clusters in input range.    ## Output parameters

### Step 4 ("Recluster (optional)")

##### After the clustering procedure is done, a user can run the clustering procedure again with a different number of clusters and (or) different output information and write the results to a different worksheet.  ## Understanding the results

• ##### Detailed Infomation - shows exactly what interval to which cluster belongs, also showing all the input data, but already sorted according to cluster affiliation. 