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
  • Notes, Settings and String Settings sheets
  • Periods sheets
  • Product related sheets
  • Location related sheets
  • Supplier sheets
  • Production sheets
  • Warehouse sheets
  • Inventory sheets
  • Transport sheets
  • Customer sheets
  • Custom Objectives sheet
• Template Attributes
  • Optimization Parameters and Constraints
  • Available
  • Product Related Attributes
  • Location Related Attributes
  • Capacity Related Attributes
  • Cost Related Attributes
  • Open/Close Related Attributes
  • Rate Card Related Attributes
  • Inventory Related Attributes
  • BOM and Production Routing
  • Transport Related Attributes
  • Customer Related Attributes
  • Custom Objectives Related Attributes
  • Count Constraint Attributes
  • Ratio Constraint Attributes
• Group Elements in the Data
• Count and Ratio Constraints
  • Count Constraints
  • Sourcing and Destination Constraints
  • Ratio Constraints