Skip to content

Synthetic Data — Excel

The Demo Factory Excel file contains three months of shift production summaries for testing the Excel Offline data source in Pirivision.

File Structure

The file Aylik_Uretim.xlsx consists of three sheets, each using the same column schema.

Sheet Rows Coverage
Ocak 30 January 2026 daily production summary
Subat 28 February 2026 daily production summary
Mart 30 March 2026 daily production summary

Column Schema

# Column Type Example Values
A Tarih Date 2026-01-01
B Hat Text HAT-1, HAT-2
C Vardiya Text V1, V2, V3
D Urun_Ailesi Text Product-A, Product-B, Product-C, Product-D
E Adet Integer 250–450

Sample Rows

Tarih Hat Vardiya Urun_Ailesi Adet
2026-01-01 HAT-1 V1 Product-A 412
2026-01-01 HAT-1 V2 Product-B 387
2026-01-01 HAT-1 V3 Product-A 401
2026-01-02 HAT-2 V1 Product-C 295
2026-01-02 HAT-2 V2 Product-D 332

Preparing the File

If you do not already have an Aylik_Uretim.xlsx file, follow these steps to create one:

  1. Open a new file in Excel and add three sheets named Ocak, Subat, and Mart.
  2. Add the column headers in the first row of each sheet: Tarih, Hat, Vardiya, Urun_Ailesi, Adet.
  3. Fill in the dates (e.g. 2026-01-01 through 2026-01-30 for January, etc.).
  4. To generate random values in the Adet column use the Excel formula: 
    =RANDBETWEEN(250, 450)
    To freeze the values, select all cells → Copy → Paste Special → Values Only.
  5. Save the file in .xlsx format (not .xls).

Adding to Pirivision

  1. Go to Port → New Data Source → Excel Offline.
  2. Upload the .xlsx file you prepared.
  3. Click Save to store the connection.

Once saved, when you select this source in Compass the sheet selector will show the Ocak, Subat, and Mart tabs.