Contractor Talk - Professional Construction and Remodeling Forum banner

1 - 1 of 1 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter · #1 ·
This is an Excel spreadsheat that was pasted here. the formating is not correct. There are three columns. KEYSTROKES, DISPLAYED VALUES, EXPLANATION. It details the four different procedures I use for figuring Rake wall stud lengths, and top plate layout. If necessary I can Email the spreadshaet, and it may be easier to understand. Norm
CONSTRUCTION MASTER RAKE WALL STUD LENGTHS AND LAYOUT OF TOP PLATE
KNOWN PITCH

KEYSTROKES DISPLAYED VALUE EXPLANATION
CONV 8 0 Displays all dimensions to the nearest 1/8". Framers are rarely required to be more accurate than this
92" M+ 92" Short point length of first stud
2½" PITCH 2½" Known pitch
240" RUN 245-1/8" RUN Total length of wall. Total length of Top Plate
15¼" RUN 15¼" RUN Typical dimension to first stud if 16" to center from start point
RISE 3-1/8" RISE Increase in length from short point of first stud to short point of this stud
DIAG 15-5/8" DIAG Distance to first stud short point along top plate
RISE 3-1/8" RISE Brings rise back to screen to add onto length of first stud
+ RCL M+ = 95-1/8" Adds rise to length of first stud for total length of stud
31¼" RUN 31¼" RUN Typical dimension to second stud if 16" to center from start point
RISE 6½" RISE Increase in length from short point of first stud to short point of this stud
DIAG 31-7/8" DIAG Distance to second stud short point along top plate
RISE 6½" RISE Brings rise back to screen to add onto length of first stud
+ RCL M+ = 98½" Adds rise to length of first stud for total length of second stud



UNKNOWN PITCH

CONV 8 0 Displays all dimensions to the nearest 1/8". Framers are rarely required to be more accurate than this
92" M+ 92" Short point length of first stud
240" RUN 240" RUN Total length of wall
18" RISE 18" RISE Total rise of wall
PITCH 7/8" PITCH Calculated pitch
DIAG 240-5/8" Total length of top plate
15¼" RUN 15¼" RUN Typical dimension to first stud if 16" to center from start point
RISE 1-1/8" RISE Increase in length from short point of first stud to short point of this stud
DIAG 15¼" DIAG Distance to first stud short point along top plate
RISE 1-1/8" RISE Brings rise back to screen to add onto length of first stud
+ RCL M+ = 93-1/8" Adds rise to length of first stud for total length of stud
31¼" RUN 31¼" RUN Typical dimension to second stud if 16" to center from start point
RISE 2-3/8" RISE Increase in length from short point of first stud to short point of this stud
DIAG 31-3/8" DIAG Distance to second stud short point along top plate
RISE 2-3/8" RISE Brings rise back to screen to add onto length of first stud
+ RCL M+ = 94-3/8" Adds rise to length of first stud for total length of second stud

ANY RUN CAN BE USED FOR ANY STUD LAYOUT, ALL OTHER KEYSTROKES REMAIN CONSTANT.
THESE TWO STEPS CAN BE ELIMINATED FOR CALCULATING LENGTH OF STUDS ONLY

CONSTANT RISE WITH KNOWN PITCH
CONV 8 0 Displays all dimensions to the nearest 1/8". Framers are rarely required to be more accurate than this
4" PITCH 4" PITCH Known pitch
16" RUN 16" RUN Constant spacing
RISE 5-3/8" RISE Rise per constant spacing
M+ 5-3/8" Rise per constant spacing entered into memory
+ 92" 97-3/8" Length of first stud plus constant rise
+ RECL M+ = 102-5/8" adds 5-3/8" (value in memory) onto each stud
+ RECL M+ = 108" adds 5-3/8" (value in memory) onto each stud
+ RECL M+ = 113-3/8" adds 5-3/8" (value in memory) onto each stud

CONSTANT RISE WITH UNKNOWN PITCH
CONV 8 0 Displays all dimensions to the nearest 1/8". Framers are rarely required to be more accurate than this
240" RUN 240" RUN Total length of wall
18" RISE 18" RISE Total rise of wall
PITCH 7/8" PITCH Calculated pitch
16" RUN 16" RUN Constant spacing
RISE 1¼" Rise per constant spacing
M+ 1¼" Rise per constant spacing entered into memory
+ 92" = 93¼" Length of first stud plus constant rise (value in memory)
+ RECL M+ = 94-3/8" adds 1¼" (value in memory) onto each stud
+ RECL M+ = 95-5/8" adds 1¼" (value in memory) onto each stud
+ RECL M+ = 96¾" adds 1¼" (value in memory) onto each stud

VALUES DISPLAYED ARE TO NEAREST 1/8". WHEN ADDING A STRING OF STORED VALUES, THE DISPLAYED VALUE 'MAY APEAR TO VARY'. THIS IS BECAUSE THE CALCULATOR IS ADDING THE ACTUAL VALUE, NOT THE ROUNDED TO THE NEAREST 1/8" DISPLAYED VALUE
 
1 - 1 of 1 Posts
Top