Below is a list of tips and tricks for the Spreadsheet Data Manager (SDMan) course. Click one of the items below to see information that may be helpful to you as you take the course.
Using the SDMan Sample File may simplify the data entry by providing sample data for the different activities.
When you enter TRUE and FALSE values into an Excel cell, Excel might recognize these as Boolean values. If Excel treats those values as Boolean, you will then receive an error when you use SDMan. To avoid this, make sure the Excel cell has a text format. A quick way to force Excel to treat the cell as a text cell is to first enter some other text in the cell, e.g., Donald Duck, press Enter, and then change the text to TRUE (or FALSE).
Attribute values are language sensitive! If you are not sure what values to use, open an appropriate overview window, e.g.,Suppliers Analysis, or Part Information Analysis and select a supplier or part carrying the value you look for..