Daryl Wood Posted February 12, 2007 Share Posted February 12, 2007 Does anyone have a formula for rounding up a real number to the next higher integer? I'm trying to get a length in dimensional feet and inches to round up to the next whole foot when the fractional part is less than 6". I want 12'4" to round up to 13'. Any ideas are appreciated. Quote Link to comment
CipesDesign Posted February 12, 2007 Share Posted February 12, 2007 Daryl, Are you trying to do a lumber take-off? Just curious... Quote Link to comment
Petri Posted February 12, 2007 Share Posted February 12, 2007 I'm a lumberjack and I'm okay... Rounding to the next higher arbitrary number (eg. lumberyard lengths) is an interesting junior high-school mathematical exercise. Rounding upwards in a set measurement scheme much less so. Just add a unit and round down. Or, in Daryl's case, if the remainder of the modulus is less than half the unit, then add etc. but then you don't get lumberyard lengths. Quote Link to comment
Daryl Wood Posted February 12, 2007 Author Share Posted February 12, 2007 Peter, yes, in part. I would like a list of joists rounded up to the nearest whole foot because rounding down is a bad thing. By rounding up I would have a framing schedule that tells carpenters to go to the material stack and get 8- 35' joists, not 8- 34'3 3/8" joists. The lumber yard will cut up to the next higher foot. This function would be used for other members as well. I sometimes have say 6 joists in a framed bay area where a couple of them lie in the 45 degree angles. I want to have all of them ID'd the same and with the length be rounded up to the nearest whole foot. Quote Link to comment
ccroft Posted February 12, 2007 Share Posted February 12, 2007 =12.75 DIV 1+1 will return 13 in a worksheet cell. DIV returns the quotient...throws away the fraction. It needs to be separated by spaces. =12.75 DIV 2+1 will return 7 Hope that works for you Charles Quote Link to comment
Daryl Wood Posted February 15, 2007 Author Share Posted February 15, 2007 Thanks Charles, I can make that work. Quote Link to comment
Grant M Posted February 16, 2007 Share Posted February 16, 2007 Daryl I've used the formula preceded by ROUNDDOWN or ROUNDUP in excel. Haven't tried it in a VW worksheet but would expect there is something similar. Quote Link to comment
Daryl Wood Posted February 16, 2007 Author Share Posted February 16, 2007 Hi Grant, yes I tried the excel functions just for kicks and could not make them work. Are you the same Grant Marshall that I see on the Sketchup forum occasionally? Welcome. Quote Link to comment
Grant M Posted February 19, 2007 Share Posted February 19, 2007 Hi Daryl. No I don't frequent the sketchup forum. I haven't had the time to explore sketchup in any great detail unfortunately. Cheers, Grant Quote Link to comment
Cris with no H Posted March 29, 2018 Share Posted March 29, 2018 for archival sake, the answer here is to use the forumula =ROUNDUP(('lumber'.'length'),0) and make sure your column is set to display numbers as Dimensions. Whole feet is easy. Rounding to whole inches is more difficult in a feet-and-inches Units setup, as I'm finding. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.