4.2. Aggregated spreadsheets

Streamline is able to import data from an Excel spreadsheet or CSV file. There are two spreadsheet connections that differ in the way the data should be organized before the import.

Watch a video tutorial (2:34)

<iframe width="500" height="285" src="https://www.youtube.com/embed/JZvnhOe8fMk" title="Aggregated Data" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>

This article describes the Aggregated spreadsheet connection. This connection requires data (sales, on-hand, and revenue histories) to be aggregated in certain periods:

Any equal periods: days, weeks, 2 days, 4 days…

Specified days within a week: workdays, holidays…

Months

Specified months within a year: winter months, quarters…

If Streamline cannot find a pattern within periods, it will work, but the future periods will be denoted as +1, +2...

Tracedump:

newBaseSize: 16pt
newBaseSizeInPt: 16