Creating a formula for periodic increases along a sloped length

Hey there.
I have a function I'd like to create but I'm not sure how to do it.

I am calculating the length of studs in a new residential building. Assuming a stud per foot perimeter including waste, the calculation is easy enough. I've subtracted my gable end walls (the walls with a peak above, aka, two small triangles), so I'm left with only an 8' stud quantity.
I would like to add in my sloping studs.

Assuming a 30' length at a slope of 10/12 and 8' walls, this will give me a height of 12.50' in the gable only, a run of 15', and a sloped length of 19.80'.

12.50 / 15 = 0.83 approximately.

So my formula would be the 8' height + 0.83' / foot until the peak of 20.50' is reached, and then mirrored again to go down the gable to the other end of the 30' wall.

I need the quantities separated by stud lengths (8-10', 10-12', 12-14', etc in 2' increments up to 24')

I would rather have this integrated into my main stud formula, though adding the values to a chart so I can manually add them where appropriate would not be so bad either.

I've included my excel file. The calculation falls under any of the exterior stud calculations, with references to sheet 2, B55:60.

Thanks for any help

Will you also be including a line to account for whether the studs are 16" on center or 24" on center?

Can't really think of a way to do it strictly with formula.
Not saying it can't be done, just saying it can't be done by me.

See if the attached example does pretty much what you need. Note that if you tell it the wall is 10 feet, it takes it as being a 10' wall sloped only upwards in one direction, AKA if you have a 30' room with a peak in the middle you'd have to punch in 15' and double it.
Well, not double it exactly but double it minus the one stud in the middle...

Anyways, see if that gives you any ideas. I can't think of a formula solution.

Did you try clicking the big grey button?

Or better yet, change the starting height, the spacing of the studs, and the slope, then click the big grey button.

I'm not sure what to do with what pops up:

Please Login or Register  to view this content.

You must have design mode turned on.

That's a macro, and runs as such.