What order should my data be in in Excel for Initialization Links?
If the node whose data resides in Excel is not conditioned, then the order of the data should match the order of the states of the node (e.g., Low, Nominal, High). The named range containing the data can be either in a row or a column in Excel. If the node is conditioned, then the reading order (i.e., across a row then down to the next row) of the data should match the order in which it appears in the node definition dialog window. For example, let Node B have three states called Low, Nominal and High. Let Node A have two states called Yes and No. Let Node B be conditioned by Node A. The order of the data for Node B in Excel should be Low|Yes, Nominal|Yes, High|Yes, Low|No, Nominal|No, High|No.