Monday, February 1, 2010

SoftList - To report stair parts

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…

No comments:

Post a Comment