Referencing Items on Other Tabs
Formulas within a configuration tab can reference parts configured on other tabs, including parts imported from external configurators.
One way to do this is by directly referencing part numbers on the Write-In Module. This is particularly useful to reference part numbers imported into the Write-In Module from manufacturer or distributor configuration/pricing tools.
Reference a part number on the Write-In Module using the following formula to sum up the total quantity of that part number on the Write-In Module:
=SUMIF(WriteInPart,”[part number]”,WriteInPartQty)
To configure quantity 1 of part number XYZ if the quantity of part number ABC on the Write-In Module is greater than zero, you would type the following formula into the Qty Calcd cell for part XYZ:
= IF(SUMIF(WriteInPart,”ABC”,WriteInPartQty)>0,1,0)
Reference in Excel formulas items that are associated with parts that are configured.
Assume there have 50 different part numbers for the PCs that you sell. The typical approach to configuring the power cords using Excel would be to reference each of the 50 PCs in the formula for the power cords. With SDA, you can use Architect Manager to associate an item called “PC” (for example) with each of the 50 PC part numbers in the SDA database. Because each quote file tracks the total count for each item across all tabs in a SDA quotation, in the power cord formula you can simply reference the total count of the item named “PC,” as follows:
=SUMIF(Item,”PC”,ItemTotal)
Find the complete list of items that can be referenced in the Item Categories table found within the Categories menu of Architect Manager. Item-part associations are established via the Engineering View.