topic Incremental for Lumber - IF function in Collaboration with other software

Incremental for Lumber - IF function

Red — Mon, 01 Feb 2021 16:37:05 GMT

I have searched around for a solution, but I have yet to find one. I know it is more than likely something small I am overlooking. I am trying to get an expression to generate the length of a beam and provide the correct lumber length for imperial sized lumber.

For example: ( I use separate lines when writing expressions out. In my opinion, it is a lot easier to read)

( IFS (
{Property:Beam/Length Left} <= 8 ', 8 ',
{Property:Beam/Length Left} >= 8'-1", 10 ',
***when it get to this stage and beyond, I need a >= 8'-1" like above and then a <= 9'-11", 10'***
{Property:Beam/Length Left} >= 10'-1", 12 ',
{Property:Beam/Length Left} >= 12'-1", 14 ',
{Property:Beam/Length Left} >= 14'-1", 16 ',
{Property:Beam/Length Left} >= 16'-1", 18 ',
{Property:Beam/Length Left} >= 18'-1", 20 ' ) ) ), 0 )

I can get one to work with just an IF function, but I hit a roadblock when I try several entries.

Re: Incremental for Lumber - IF function

poco2013 — Mon, 01 Feb 2021 21:20:19 GMT

IFS ( {Property:Beam/Length Left} <= 8 ', 8 ',
{Property:Beam/Length Left} >= 8'-1", 10 ',
{Property:Beam/Length Left} >= 10'-1", 12 ',
{Property:Beam/Length Left} >= 12'-1", 14 ',
{Property:Beam/Length Left} >= 14'-1", 16 ',
{Property:Beam/Length Left} >= 16'-1", 18 ',
{Property:Beam/Length Left} >= 18'-1", 20 ' )

Too many parenthesis , also last value in ifs is always true
See help in "What's this"

Re: Incremental for Lumber - IF function

Red — Mon, 01 Feb 2021 21:35:04 GMT

The issue that I am running into is with this setup, once I get past 10'-0", everything gets set as a 10'. Because technically everything is greater than 10'-1" past that mark unless I can set a range for each, pcs of lumber. I think it needs:

{Property:Beam/Length Left} >= 10'-1" OR {Property:Beam/Length Left} <= 11'-11", 12 '

However, I am formatting it wrong...

In what I posted earlier, I forgot to remove the extra parenthesis at the end, I was using several data conversion in another expression when I copied it.

Re: Incremental for Lumber - IF function

Red — Mon, 01 Feb 2021 21:52:35 GMT

B001 is 8'-0" long and shows correctly at 8
B002 is 8'-1" long and shows correctly at 10
B003 is 10'-1" long and shows incorrectly at 10

Re: Incremental for Lumber - IF function

DGSketcher — Mon, 01 Feb 2021 23:36:15 GMT

Rather than all the IFs try looking at it as a maths problem, see if this offers a better solution...

https://help.graphisoft.com/AC/24/INT/#t=_AC24_Help%2F045_PropertiesClassifications%2F045_PropertiesClassifications-19.htm%23XREF_24831_Round_Up_to&rhsearch=evaluate&rhsyns=%20

Re: Incremental for Lumber - IF function

Red — Tue, 02 Feb 2021 02:30:59 GMT

The lightbulb in my head is slowly warming up....

Re: Incremental for Lumber - IF function

Red — Tue, 02 Feb 2021 02:53:18 GMT

STR ( STRTONUM ( STRCALCUNIT ( MROUNDUP ( {Property:Beam/Length Left}, 24 " ) ) ), 0 )

Re: Incremental for Lumber - IF function

Red — Tue, 02 Feb 2021 02:57:32 GMT

Autotext label with the formula...