I use the MROUNDUP method suggested by Gerry to produce timber/steel member schedules (see example attached) but use it slightly differently…
Timber in the UK is normally supplied in standard lengths (your preferred sizes with the exception of one), starting @2400mm increasing in size by multiples of 600mm e.g. 2400, 3000, 3600, 4200, 4800, 5400, 6000 etc. So…
I divide the actual member length (3D length, length etc) by 600, then roundup this figure to the nearest whole number and multiplying this result by 600 (see attached image of formula used). As an example, a timber measuring 1546mm long would give…
1546/600 = 2.57
round up to nearest whole number = 3
3 x 600 = 1800
I don’t mind the schedule reporting timber lengths of less than 2400mm as all smaller lengths (multiples of 600) can be combined to make a standard length e.g. schedule reports 2no @1800, so we only need 1no @3600. This keeps the waste to a minimum.
The beauty of doing it this way is that the formula can be easily adjusted to suit other standard length intervals e.g. change the 600 to 400
Note the bug on the schedule (I need to report this separately to GS) for the figures given in the ‘Length (cut)’ field. Merge uniform items is ticked for this schedule but for some reason the schedule sums up the values in this field even though all the lengths are identical e.g. 7th row shows 16,616 but this should show 2077 (it does if you highlight the field). However, it works correctly for the ‘Length (uncut)’ field & the flagged totals which gives me the information I need.
AC16-24 Solo (latest version)
OSX 10.15.6 - MacBook Pro 16" 2.4 GHz 8-Core Intel Core i9 - 64Gb DDR4 - AMD Radeon Pro 5500M 8 GB