There are three ways to populate information in the worksheet:
a)Import a file, type or paste data directly into the cells provided. No validation is performed until you run the ‘Validate only’ or ‘Validate and Upload’ program, or open the data entry forms. You can use formulas and cell references to populate a cell.
b)Use the data-entry forms (Items, Revisions, Routings, Operations and Operation Resources, Alternate Resources forms) to enter the data into the worksheet. Information is validated and lists of values are available. To enter data in this way first position your cursor on the row you wish to contain the data. Then double-click in one of the cells or alternatively click on the ‘Forms’ icon on the Routing Wizard ribbon.
c)Use the ‘Download Form’ or ‘Download using sheet data’ buttons to download existing Routings and associated components. You can then use one of the methods above to update information prior to loading into Oracle.
The following sections will describe each of the forms within the Routing Wizard and the additional functionality for loading routings.
