You can use many of the functions available in Excel within the calculation used to call out materials in SmartBuild. If you have an Excel expert then they would be a good resource to help create these types of packages for your business.
Read the attached file for examples and helpful hints.