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, not0.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.
