I'm a novice when it comes to formulas and currently trying to write one that will report on bulk quantities of diagonal strap bracing required for a custom wall type which includes arbitrary Solids to represent metal strap bracing. Our company purchases 30 x 0.8 mm metal strap bracing at a rate of $2.15 / kg with each kg containing 5.5 lineal meters.
First I started with the Lumber Format and entered 5500 in the Order Length box and created a Lumber Pricing Table (see Image 3) called "metal_strap" which contains the order length and price per lineal meter. However SL didn't like it because the combine options are set to cut lengths between 1800 and 6000 with increments of 300 to suit order lengths for Studs, Lintels, etc.
Instead, the Custom Formula I created (see Images 1 & 2) is cutting from smaller lengths and when I replace the @length variable with 5.5m, it reports (incorrectly) that all lengths are 5.5m to be cut from 5.7m.
How do I get SoftList to cut from only 5.5m lengths as per the Lumber Pricing Table?
Thanks in advance!