Skip to main content

Escalator Sample Duty Table: Columns and Values

All columns of the escalator duty table for the Escalator Builder, the values they take, and how EAO checks them.

Written by Sabine Bunese

The escalator duty table is the Excel file you fill in to create escalator configurations with the Escalator Builder. Download it with Download Sample Duty Table, enter your escalator data, and upload it again.

EAO checks every value against the ESCALATOR_VALIDATE sheet before it builds anything. This page lists all columns and the values they take.

How the file is built

  • Sheets: the sample has three sheets:

    • READ ME explains the file.

    • ESCALATOR holds your data.

    • ESCALATOR_VALIDATE holds the values EAO accepts for each column.

  • Header rows 1–4:

    • Row 1 groups the columns: ESCALATOR for the whole escalator, UNIT for one unit.

    • Row 2 has the readable column names.

    • Row 3 has the column names EAO recognises the columns by. They are the same in every workbook.

    • Row 4 names the parameter of the reference model that EAO fills from the column. An empty cell means EAO only reports the column.

      WARNING: Don't change or delete these rows.

  • Data rows: start in row 5. Each row is one escalator model. The sample rows are examples: overwrite them or delete them.

  • One type and one unit system per sheet: a sheet holds one escalator type and one Is Imperial value.

  • Escalator and unit in one row: when a planner creates an escalator, EAO copies the UNIT values to each unit. The arrangement decides how many units there are. The planner can then change each unit on its own.

Value lists

In some columns you can enter several values at once, in curly brackets and separated by semicolons, for example {EINZEL;PARALLEL;KREUZLAUF} or {0.5;0.65;0.75}. EAO combines the lists into all possible configurations.

  • Allowed in: Escalator Arrangement, Arrangement Type, Shift, Step Width, Flat Steps, Inclination and Speed.

  • Escalator Arrangement and Arrangement Type are paired by position: the first arrangement goes with the first type, and so on.

  • Shift only applies to the criss-cross arrangement.

  • Write numbers without trailing zeros: 0.5, not 0.50.

  • Don't leave empty entries in a list, for example {EINZEL;PARALLEL;}.

Escalator columns

Column (row 2)

Column name (row 3)

What to enter

Values in the sample

Designation

Title

The name of the model as planners see it

LDE Common Escalators

Model Name

SupplierCode

The code of the model. EAO groups the rows by it. Rows with the same code must have the same Escalator Type, Model Type and Is Imperial.

LDECommon

Escalator Type

EscalatorName

The kind of installation, as text

Escalator

Model Type

EscalatorType

The kind of installation, as a code: 1 escalator, 2 inclined moving walk, 3 horizontal moving walk

1

Escalator Arrangement

Arrangement

The arrangement: EINZEL (single), PARALLEL (parallel), KREUZLAUF (criss-cross)

{EINZEL;PARALLEL;KREUZLAUF}

Arrangement Type

ArrangementType

The arrangement as a code: 1 single, 2 parallel, 3 criss-cross. Pairs with Escalator Arrangement by position.

{1;2;3}

Shift

Shift

True for criss-cross-shifted, False for criss-cross. Only used with the criss-cross arrangement.

{True;False}

Is Imperial

IsImperial

False for metric, True for imperial

False

NOTE: A horizontal moving walk (Model Type 3) can only be single or parallel.

Unit columns

Column (row 2)

Column name (row 3)

What to enter

Values in the sample

Step Width

StepWidth

The step width in mm

600, 800 or 1000

Flat Steps

FlatSteps

The number of flat steps. EAO only reports this value; it doesn't change the model.

2 or 3

Horiz. Max (MW)

HorizontalLengthMax

Moving walks only: the longest horizontal length in mm

—

Horiz. Min (MW)

HorizontalLengthMin

Moving walks only: the shortest horizontal length in mm

—

Upper Truss Length Min

UpperTrussLengthMin

The shortest upper truss length in mm

1200

Upper Truss Length Max

UpperTrussLengthMax

The longest upper truss length in mm

1600

Lower Truss Length Min

LowerTrussLengthMin

The shortest lower truss length in mm

1400

Lower Truss Length Max

LowerTrussLengthMax

The longest lower truss length in mm

2200

Inclination

Inclination

The inclination in degrees

30 or 35

Speed

Speed

The speeds the model offers, in m/s

{0.5;0.65;0.75}

Vert. Rise Min

VerticalRiseMin

The lowest travel (floor-to-floor height) in mm

1000

Vert. Rise Max

VerticalRiseMax

The highest travel in mm

6000

The truss length and travel limits are what planners see as the allowed window in the escalator configurator.

NOTE: Moving walks don't need Inclination, Flat Steps or Vert. Rise.
​Horiz. Min and Horiz. Max are for moving walks only.

The ESCALATOR_VALIDATE sheet

The ESCALATOR_VALIDATE sheet has the same header rows as ESCALATOR. From row 5 down, it lists the values EAO accepts for each column. Read it column by column: the rows aren't records.

Kind of column

Columns

How EAO checks it

Codes

Model Type, Arrangement Type

Only 1, 2 or 3

Range

Upper / Lower Truss Length, Vert. Rise

Exactly two entries: row 5 is the lower bound, row 6 the upper bound

Value list

Every other column with entries

The value must match one of the entries exactly, including upper and lower case

Empty column

Designation, Horiz.

Not checked

Values allowed in the sample's ESCALATOR_VALIDATE sheet:

Column

Allowed values

Model Name

LDECommon

Escalator Type

Escalator

Model Type

1

Escalator Arrangement

EINZEL, PARALLEL, KREUZLAUF

Arrangement Type

1, 2, 3

Shift

False, True

Is Imperial

False, True

Step Width

600, 800, 1000

Flat Steps

2, 3

Upper Truss Length

1200–1600

Lower Truss Length

1400–2200

Inclination

30, 35

Speed

0.5, 0.65, 0.75

Vert. Rise

0–15000

NOTE: If you add a model or a value, add it to ESCALATOR_VALIDATE too. Otherwise EAO refuses the duty table and names the sheet and column to fix.

Did this answer your question?