Referencing Another Sheet in Model Builder
Following is a list of Sheets and what references actually retrieve data.
Group/Division/ML sheet
Mill
Machine
External data
Settings
Mill sheet
Machines Subindustry
Materials Subindustry
Material
Settings
Machines Subindustry sheet
Machine
External data
Materials Subindustry and it’s children (under same parent in tree inside project)
Machines Subindustry and it’s children (under same parent in tree inside project)
Settings
Materials Subindustry sheet
Machines Subindustry and it’s children (under same parent in tree inside project)
Materials Subindustry and it’s children (under same parent in tree inside project)
Material
Settings
Machine sheet
own parent Machines Subindustry
Materials Subindustry and it’s children (under same parent in tree inside project), if External data is on different node (ctageory) - 'break node rule' is required
sibling Machines Subindustry and it’s children (another Machine with 'break node rule') only (under same parent (Mill) in tree inside project)
Settings
Material sheet
Machines Subindustry and it’s children (under same parent in tree inside project)
Materials Subindustry and it’s children (under same parent in tree inside project)
Settings
External data sheet
Machines Subindustry and it’s children (under same parent in tree inside project)
Materials Subindustry and it’s children (under same parent in tree inside project)
Settings
sibling Machines Subindustry only (under same parent (Mill) in tree inside project)
Settings sheet
Machine
External data
Referencing replicable rows and blocks
From static to replicable row | From static to replicable block | From static to service block |
|---|---|---|
sum of all filtered values in replicable row | sum of all filtered values in replicable block’s row | cell to cell reference |
From replicable row to static row | From replicable row to replicable row | From replicable row to replicable block | From replicable row to service block |
|---|---|---|---|
each material list’s row will have same reference of static row | values retrieved based on material | values retrieved based on material | values retrieved based on material |
From replicable block to static row | From replicable block to replicable row | From replicable block to replicable block | From replicable block to service block |
|---|---|---|---|
each material row will have same reference of static row | values retrieved based on material | values retrieved based on material | values retrieved based on material |
From service block to static row | From service block to replicable row | From service block to replicable block | From service block to service block |
|---|---|---|---|
cell to cell reference | values retrieved based on material | values retrieved based on material | values retrieved based on material |