Data Management

Excel Upload Panel

Update all dashboard data by uploading Excel files. For each category, first download the template, fill in your data, and upload it back.

Total Categories

18

Uploaded

3

Using Sample Data

15

How it works

  1. Click Download Template for the relevant category.
  2. Fill in the sheets of the downloaded Excel file with your own data. Do not rename the sheets.
  3. Upload the file back via Upload Excel for the same category.
  4. Dashboard pages update instantly with the new data.
ULOUploaded

Customer Orders

Sales document list with customer, material, quantity and value.

Excel Sheets (1)

Source
ULO Customer Orders.xlsx8634 rows

Last updated: May 19, 2026 at 08:38 AM

ULOSample data

Shipments to Customers

Customer shipments and carrier distribution.

Excel Sheets (3)

ShipmentsWeeklyShipmentsCarrierShare
ULOUploaded

General (Revenue)

Monthly revenue, cost and profit trends.

Excel Sheets (3)

MonthlyRevenueExpensesSalesTrend
2026-03 ULO Financials_v1.xlsx30 rows

Last updated: May 15, 2026 at 01:04 PM

ULOSample data

Sales

Sales by brand, country and customer with monthly trends.

Excel Sheets (4)

SalesByBrandSalesByCountrySalesTrendTopCustomers
ULOSample data

Claims

Opened/closed claims and reason distribution.

Excel Sheets (3)

ClaimsClaimsTrendClaimsByReason
ULOSample data

Inventory Report

ULO finished goods stock by material type, batch, storage location, and top items.

Excel Sheets (5)

ByTypeByStatusByBatchByStorageTopItems
ULOSample data

KPI & Weekly Trends

OTIF, quality, stock turnover, target achievement.

Excel Sheets (3)

WeeklyKPIScorecardRadar
ULOSample data

Logistics Cost

ULO logistics cost breakdown by type, budget vs actual, and vendor spend.

Excel Sheets (5)

MonthlyCostBreakdownBudgetActualSalesRefTopVendors
OESSample data

Customer Orders

OES open / closed orders and customer distribution.

Excel Sheets (3)

OrdersOrdersByStatusTopCustomers
OESSample data

Shipments to Customers

OES customer shipments and carrier distribution.

Excel Sheets (3)

ShipmentsWeeklyShipmentsCarrierShare
OESSample data

General (Revenue)

Monthly revenue, cost and profit trends for OES.

Excel Sheets (2)

MonthlyRevenueSalesTrend
OESSample data

Sales

OES billing data — monthly revenue, top customers, top products, billing type split.

Excel Sheets (4)

SalesMonthlyTopCustomersTopProductsByType
OESSample data

Claims

OES opened/closed claims and reason distribution.

Excel Sheets (3)

ClaimsClaimsTrendClaimsByReason
OESSample data

Inventory Status

Inventory value breakdown by category, PROD/PURC split, and Top 10 items per category.

Excel Sheets (10)

TotalProd-PurcTOP10 Raw materialsTOP10 Trading GoodsTOP10 Semifinished Product - MzTOP10 Semifinished Product - PlElectronicWIPFinished ProductTDU
OESSample data

KPI & Weekly Trends

OEE, quality, scrap, productivity weekly KPIs.

Excel Sheets (3)

WeeklyKPIScorecardRadar
OESSample data

Assembly Planning

Assembly line schedule and daily performance.

Excel Sheets (3)

AssemblyPlanDailyOutputUtilization
OESSample data

Injection Planning

Injection machine schedule, OEE and downtime reasons.

Excel Sheets (3)

InjectionPlanOEEDowntime
BudgetUploaded

Budget 2026

Sales budget vs actual — Spare parts, ULO and OES & ULO combined.

Excel Sheets (1)

Sheet1
Sales 2026.xlsx5 rows

Last updated: May 15, 2026 at 01:52 PM