Input Template
The module used by the user, affects the input data that can be provided in the Excel template. Each Module allows different data. You can read more about Modules in User Roles and Modules. If you define input data that is not allowed by your Module, a data validation message will appear, indicating that the input does not meet the required criteria for that specific Module.
In this section we discuss the following general topics to better understand how the application works:
Template Sheets walks through each Excel sheet tab by tab — what it is for and how to fill it in. Template Attributes is the field-level reference: many attributes appear on several sheets, so use it when you need the input rules or model effect of a specific attribute. The two sections cross-link throughout: every attribute lists the sheets it appears on, and every sheet links to the attributes relevant to it.
- Template Sheets
- Template Attributes
- Optimization Parameters and Constraints
- Product Attributes
- Location Attributes
- Available
- Capacity Attributes
- Cost Attributes
- Open/Close Attributes
- Count Constraint Attributes
- Ratio Constraint Attributes
- BOM and Production Routing Attributes
- Inventory Attributes
- Transport Attributes
- Rate Card Attributes
- Load Consolidation Attributes
- Lead Time Offset Attributes
- Customer Attributes
- End-to-End (E2E) Lead Time Attributes
- Custom Objectives Attributes
- Transport Navigator Attributes
- Group Elements in the Data
- Count and Ratio Constraints