--- title: "Analysis of material data" slug: "materialmanager-in-a-nutshell-analysis-of-material-data" updated: 2026-07-29T09:32:40Z published: 2026-07-29T09:32:40Z canonical: "docs.homag.cloud/materialmanager-in-a-nutshell-analysis-of-material-data" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.homag.cloud/llms.txt > Use this file to discover all available pages before exploring further. # Analysis of material data The data from the materialManager and materialAssist can be accessed from Excel via the [HOMAG Connect interface](/v1/docs/en/materialmanager-kurz-erklaert-connect-api) . This allows for easy evaluation of the data. We have created various templates that can serve as a basis for an evaluation. The handling is described on the page Evaluating [data with Excel](/v1/docs/en/datenaustausch-homag-connect-daten-mit-excel-auswerten). ## Slow sellers - records and leftovers Excel Template: [Candidates for Disposal (Plates).xltx](https://github.com/HomagGroup/HOMAG-Connect/blob/main/Applications/MaterialAssist/Samples/Statistics/Excel/Templates/DisposalCandidates/Kandidaten%20f%C3%BCr%20die%20Entsorgung%20(Platten).xltx) Over time, plates and leftovers accumulate in the warehouse that are no longer needed. From time to time, space has to be created again. The report helps to identify the slow sellers. The report can be printed and the QR code can be scanned with the materialAssist boards to quickly find the plate or the rest in the warehouse. ![Übersicht über die Lagerbestände. Alle Platten sind nach Alter und Typ sortiert. Der QR-Code kann direkt im materialAssist verwendet werden, um die Platte zu entsorgen.](https://cdn.document360.io/43eaea7e-f51c-41df-9b73-bf55e0b1d20d/Images/Documentation/2024-12-18-Disposal-candidates-01-de.png?sv=2026-02-06&spr=https&st=2026-11-09T23%3A47%3A01Z&se=2026-11-10T00%3A47%3A01Z&sr=c&sp=r&sig=MUJr%2BYlAnU%2FdrC0spCmiajEKFup3zDjaZ1KcoiVGrEg%3D) Overview of stock levels. All plates are sorted by age and type. The QR code can be used directly in the materialAssist to dispose of the plate. ## Slow sellers - edge tapes Excel Template: [Candidates for Disposal (Edge Tape).xltx](https://github.com/HomagGroup/HOMAG-Connect/blob/main/Applications/MaterialAssist/Samples/Statistics/Excel/Templates/DisposalCandidates/Kandidaten%20f%C3%BCr%20die%20Entsorgung%20(Kantenband).xltx) Like slabs and scraps, edges accumulate over time. The report helps to clean up. ![Übersicht über die Lagerbestände. Alle Kanten sind nach Alter und Typ sortiert. Der QR-Code kann direkt im materialAssist verwendet werden, um das Kantenband zu finden.](https://cdn.document360.io/43eaea7e-f51c-41df-9b73-bf55e0b1d20d/Images/Documentation/2024-12-18-Disposal-candidates-02-de.png?sv=2026-02-06&spr=https&st=2026-11-09T23%3A47%3A01Z&se=2026-11-10T00%3A47%3A01Z&sr=c&sp=r&sig=MUJr%2BYlAnU%2FdrC0spCmiajEKFup3zDjaZ1KcoiVGrEg%3D) Overview of stock levels. All edges are sorted by age and type. The QR code can be used directly in materialAssist to find the edge band. ## Development of inventory in the warehouse Power BI Template: [Development Inventory (Disks).pbit](https://github.com/HomagGroup/HOMAG-Connect/blob/main/Applications/MaterialAssist/Samples/Statistics/PowerBI/Templates/InventoryDevelopment/Entwicklung%20Bestand%20(Platten).pbit) This report provides a comprehensive overview of the development of inventories over time, from which any need for action can be derived. A continuous increase in remaining stocks may indicate that it makes sense to adjust the material-dependent parameters. If certain materials tie up a lot of capital, it may be advisable to rethink the purchasing strategy for these materials. ![Der Bericht gibt einen Überblick über die Entwicklung der Bestände im Laufe der Zeit. Dabei wird zwischen der Anzahl der Platten, der Gesamtfläche in m² und dem Wert in € unterschieden.](https://cdn.document360.io/43eaea7e-f51c-41df-9b73-bf55e0b1d20d/Images/Documentation/DataAnalysis-InventoryOverTime-01-de.png?sv=2026-02-06&spr=https&st=2026-11-09T23%3A47%3A01Z&se=2026-11-10T00%3A47%3A01Z&sr=c&sp=r&sig=MUJr%2BYlAnU%2FdrC0spCmiajEKFup3zDjaZ1KcoiVGrEg%3D) The report provides an overview of the evolution of stocks over time. A distinction is made between the number of panels, the total area in m² and the value in €. ## Stock Remains by Length, Width and Value Power BI Template: [Leftovers (Size and Rating).pbit](https://github.com/HomagGroup/HOMAG-Connect/blob/main/Applications/MaterialAssist/Samples/Statistics/PowerBI/Templates/InventoryDevelopment/Entwicklung%20Bestand%20(Platten).pbit) This report provides an overview of the stock of leftovers, differentiating by number, size, and value. It helps to identify residues where the handling effort exceeds the value. If there are many small leftovers with a low value, it is advisable to adjust the [material-dependent parameters](/v1/docs/en/materialmanager-materialabhaengige-parameter-optimierung) . ![Bestand an Resten nach Länge, Breite und Kategorie](https://cdn.document360.io/43eaea7e-f51c-41df-9b73-bf55e0b1d20d/Images/Documentation/DataAnalysis-OffcutSizeAndValue-01-de.png?sv=2026-02-06&spr=https&st=2026-11-09T23%3A47%3A01Z&se=2026-11-10T00%3A47%3A01Z&sr=c&sp=r&sig=MUJr%2BYlAnU%2FdrC0spCmiajEKFup3zDjaZ1KcoiVGrEg%3D) Stock of remains by length, width and category ## Parts History Excel Template: [Part history.xltx](https://cdn.document360.io/43eaea7e-f51c-41df-9b73-bf55e0b1d20d/Images/Documentation/Part_history.xltx?sv=2026-02-06&spr=https&st=2026-11-09T23%3A47%3A01Z&se=2026-11-10T00%3A47%3A01Z&sr=c&sp=r&sig=MUJr%2BYlAnU%2FdrC0spCmiajEKFup3zDjaZ1KcoiVGrEg%3D) In the part history, there is a complete record of which part was cut for which order and when with the help of productionAssist Cutting - including information on the time, workplace or sheet material used, right down to the ID of the plate used or the remainder. This ensures efficient and complete traceability of your production steps. ![Historie der zugeschnittenen Teile](https://cdn.document360.io/43eaea7e-f51c-41df-9b73-bf55e0b1d20d/Images/Documentation/DataAnalysis-part-history-01.png?sv=2026-02-06&spr=https&st=2026-11-09T23%3A47%3A01Z&se=2026-11-10T00%3A47%3A01Z&sr=c&sp=r&sig=MUJr%2BYlAnU%2FdrC0spCmiajEKFup3zDjaZ1KcoiVGrEg%3D) History of the cut parts ![Historie der zugeschnittenen Teile](https://cdn.document360.io/43eaea7e-f51c-41df-9b73-bf55e0b1d20d/Images/Documentation/DataAnalysis-part-history-02.png?sv=2026-02-06&spr=https&st=2026-11-09T23%3A47%3A01Z&se=2026-11-10T00%3A47%3A01Z&sr=c&sp=r&sig=MUJr%2BYlAnU%2FdrC0spCmiajEKFup3zDjaZ1KcoiVGrEg%3D) History of the cut parts --- ## References ### Links - [Evaluate data with Excel](/v1/docs/en/datenaustausch-homag-connect-daten-mit-excel-auswerten) - [Evaluate data with Power BI](/v1/docs/en/datenaustausch-homag-connect-daten-mit-power-bi-auswerten)