Overview
BOXCOMPONENTCOST will lookup the ‘key’ in file called componentcost.csv located in the BoxUp Extension App folder. This file can be edited with BoxUp ‘Component cost list’ found in the BoxUp menu. The file can also be edited with most spreadsheet applications. The ‘key’ can be constructed with other Dynamic Component functions to uniquely identify component, like component name, size, material and so on. If the key was NOT found, the key will be added to the file with a cost of 0. If component.csv does not exist, if will be created. Learn more… Cost calculations overview
Parameters
- ‘key’ must be a text string
Returns the cost found using the ‘key’, 0 if no ‘key’ was found
Error None
Sample usage
=BOXCOMPONENTCOST(CONCATENATE(BOXDEFNAME(),” “,BOXLOOKUP(“modul_y”)))
This formula could find the cost of a drawer slide, where the key contains the definition name i.e. ‘Drawer slide telescopic’ and lookup a cabinet’s drawer depth i.e. ‘500’, resulting in a key ‘Drawer slide telescopic 500’.