Sunday, January 31, 2010

SoftList Stairs Formula

For Treads: Formula should read

if matches (type, straight)
if matches (stair_material, regular)
set_dimens (feet_inches,inches,feet_inches )
lumber ( tread_count,1",roundup(tread_depth,1"),width,SYP)
endif
endif

For Risers: Make changes to Units = each and Quantity = 1
Change to Custom Formula

Formula should read
if matches (type, straight)
if matches (stair_material, regular)
set_dimens (feet_inches,inches,feet_inches )
lumber ( riser_count,1",roundup(riser_height,1"),width,SYP)
endif
endif

1 comment:

  1. To report for stringers, treads, risers

    1) Select Build > Material List > setup > material definition > edit material
    2) Find the stairs in the list (use edit > find)
    3) Under the Main Stairs heading, select the stairs row
    4) Change the setting for this row in the include column to No
    We need to create formulas for stringers, treads, risers
    This is for an interior straight stair
    First the Stringer:
    5) Click on the Insert button at the bottom
    6) Select Stair from the New Material pop up window
    7) The Material Setup Group Stair Window opens
    8) In the Material Name box, type Stair Stringer
    9) Set include box to Yes and Units box to each
    10) Set Stair Type as Straight, Material as regular stair
    11) Under Calculation Method, Select Lumber Format
    12) Under Quantity select single piece
    13) Under Value click the ? to the right of the Total Length Box
    14) Select Functions > hypot
    15) Click Add to Formula button. Format is hypot(x,y)
    16) Notice the ( ). Add the rise, run between the parens
    17) Should read hypot(rise,run)
    18) Type 2" in the Thickness box
    19) Type stringer_depth in the Depth Box. Set unit to inches
    20) Select Spruce in the Lumber Table box
    21) Click the Accounting tab.
    22) Under Tracking area > sequence, enter 3100
    23) Click OK to close
    24) Change Calculation Method to Custom Formula, click Yes
    25) Formula window opens
    26) Locate the row headed by Lumber
    27) Change the number 1 at the start of the formula to num_stringers
    Formula should read
    if matches (type, straight)
    if matches (stair_material, regular)
    lumber ( num_stringers,2",stringer_depth,hypot(rise,run),spruce)
    endif
    endif
    28) Click OK > Save Changes > Click Yes
    Second the Tread:
    29) Locate the Stringer item we just created in the report
    30) Click on the Insert button at the bottom
    31) Choose Stair from the new Material Menu
    32) Click OK
    33) Material Setup Window Opens
    34) In Material Name box type Stair Treads
    35) Change Units box to feet
    36) Under Stair Type select straight
    37) Under Material select regular stair
    38) Under Calculation Method select Lumber Format
    39) Under Quantity select Lineal Feet
    40) Under Price Lumber As, type 16'
    41) Under Value in Total Length box enter width*tread_count
    42) In Thickness box type 1"
    43) In Depth box type roundup(tread_depth,1")
    44) Set Units box to inches for the Depth
    45) Lumber Table box set to Spruce
    46) Click Accounting button
    47) In sequence box type 3100
    48) Click Ok > Save Changes
    Third the Risers:
    49) Insert new formula beneath treads formula
    50) Material Name > Stair Riser
    52) Units to feet
    53) Stair Type > straight, Material > regular stair
    54) Calculation Method > Lumber Format
    55) Quantity > Lineal Length
    56) Price Lumber As 16’
    57)Under Value set Total Length to width*riser_count
    58) Set Thickness to 1”
    59) In Depth box roundup(riser_height,1”) set Units > inches
    60) Lumber Table > Spruce
    61) Accounting > Sequence > 3100
    62) Click OK twice > Save Changes
    63) Click OK in Material List Window
    64) Generate Report > Find Stairs
    65) Notice Stringer, Tread, Riser counts

    Sorry for the length but wanted to have it clear, Change the dimensions for the treads and risers to suit your material size. 1” treads, 1” risers. ¾” treads, ¾” risers, etc…

    ReplyDelete