I need to find a way to round the lengths of these I-Joists tot he nearest, even, whole number. I am working on doing some Joist layouts and I would like to be able to pull the schedule right to the Sheet and print the quantities, lengths, and families without having to build a spreadsheet by hand. Is there a way to enter a formula that can round these lengths up to the lengths that my yard carries?
a calculated parameter using "roundup" or "rounddown", or just change the reported unit's accuracy for the field.
It looks like the Length in your Schedule is rounding off to the nearest inch, but the framing plan is showing fractions?
When you say "nearest, even whole number" do you mean to the nearest foot?
If you want the fractions to go away, the BEST way is to set your Project Units Length to 1/256" tolerance, and MOVE/adjust the geometry to make the undesired fractions go away.
Another way is to set your Project Units and Dimension Style to round to the nearest inch. This will make the dimensions read nicely, but be careful as it can lead to errors as the rounding can add up over long distances.
These can be "rounded off" using methods mentioned in the replies to your post.
But--I'd be careful. The model needs to be built so the joists are actually the correct length. Looks like they are bearing on some steel beams. Which likely bear on columns and footings. These will be built first and drive the dimensions of the rest of the framing.
If you round them, make sure to round UP! ( I'm sure you know why 🙂
