Syntha Lab RU

Footwear size run 36–41 with half sizes

A split of 330 pairs of one style across EU sizes 36–41 in half steps: foot length, share, pairs in total and pairs per color (3 colors).

Size runs 7 columns 5 example rows

Download CSV ↓

What the template is for

Preparing a women footwear order and finding edge sizes that cause broken runs.

What one row is
one row = a size of a style

Columns

ColumnCodeTypeRequiredValidation rule
Style SKUmodelTextyesone SKU for all sizes
Size EUsizeNumberyesa number from 35 to 42 in steps of 0.5
Foot length, mmfootNumberyescalculated: EU × 20 ÷ 3 − 12
Share in the curve, %shareNumberyesfrom 0 to 100
Pairs in totalpairsIntegeryesan integer not below 0; the sum equals the order size
Pairs per colorperColourNumberyescalculated: pairs ÷ number of colors (3)
Size classclassList valueyescore or edge; edge if the share is below 5%

Example rows

Style SKUSize EUFoot length, mmShare in the curve, %Pairs in totalPairs per colorSize class
W-BOOT-02362282.582.7edge
W-BOOT-0236.5231.34.9165.3edge
W-BOOT-0237234.78.2279core
W-BOOT-0237.523811.83913core
W-BOOT-0238241.314.74916.3core

The example data is illustrative: an exercise, replace it with your own.

Note

The curve is normal with a center at 38.5 and σ = 1.3: an exercise assumption for the women group, not sales statistics. Take your own curve from sales by size. Edge sizes (36, 36.5, 41) get 1–3 pairs per color: keep them in the DC and online. A maker guide; check it against your size chart.

How to open the file

The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.

Calculations that use these fields

Documents that need this data

Download CSV ↓ Open interactively →