So here is where I'll try to compile some of the equations I've used in the past. I look forward to seeing what y'all do out there.
That's awesome. Thanks for sharing!!I’m enjoying this Wallmaxx, years ago, in an attempt to be a more efficient framer, I made these little charts and laminated them.
Along with a $4.00 calculator I got pretty good at generating cut lists, ridge props, ridge lengths, etc.
It took many nights of studying trig- which I hated- but it made me a better roof man
I would mark on the subfloor before the walls went up where each ridge started and stopped, ridge prop lengths and locations, ridge to ridge hips and valleys, etc
The guys could see in 2 dimensions what my cut pile would end up being in 3 dimensions
Now a construction master has replaced my cheat sheets- but that’s okay-time marches on View attachment 488951
View attachment 488953
Might try a if then function. If previous two cells subtracted is than 12(") return ' ' (blank cell). If not perform function for next jack. Run 5 cells with just the jack function, then run 10-15 with the If then formula. Should get blank cells after the last jack is less than 12", in theory.So I'm trying to get an Excel equation to do this RPN action:
DO N D N - 'D' STO
UNTIL D 0 ≤
END
It's a DO - UNTIL - END string.
It takes an increment length (N) and subtracts it from (D) then re-saves it over the original (D) and continues subtracting (N) from the ever reduced (D) until it reaches zero.
It does this:
Say you have a 2' increment (N) and your longest jack is 12' (D)
12' - 2' = 10' (export to the stack and re-save as D)
10' - 2' = 8' (export to the stack and re-save as D)
8' - 2' = 6' (export to the stack and re-save as D)
6' - 2' = 4' (export to the stack and re-save as D)
4' - 2' = 2' (export to the stack and re-save as D)
2' - 2' = 0' (export to the stack and re-save as D)
END
The list generated is:
10'
8'
6'
4'
2'
0'
This is how I can calculate jack rafters in RPN and if I can get this into excel, I'll post a spreadsheet that should help calculate most hand cut roof systems. This is the only headache I have been unable to figure out.
I think the part that was stumping me was how to make it stop when it hits zero or a negative number but if I create enough cells to cover the maximum possible number of Jack rafters then I would just have to know that when the number becomes negative that’s not something I would be cutting in reality. I think that would work. Thank you. I’ll let you know what happens.Might try a if then function. If previous two cells subtracted is than 12(") return ' ' (blank cell). If not perform function for next jack. Run 5 cells with just the jack function, then run 10-15 with the If then formula. Should get blank cells after the last jack is less than 12", in theory.
Did not try this exactly. But have used it in complex spread sheets for calculating cabinetry material and not have calculated results were there were no number of unit entries, kind of gig. If that makes sense.