Question Locked

calculate how many 12 ft lengths can be used in a given perimeter in excel

0 helpful
11 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
i wanted to know if anyone can generate a formula that can figure out how many 12 feet lengths can be used in a given perimeter. I.E.; a window is 24" X 36", the perimeter is 120 inches. Each trim is 144 inches long, and will be installed around the perimeter of each window. How many trims will i need to complete a job with 47 windows at the same size. Now, keep in mind that if the perimeter is 120", i have 24" left in the first trim that i can still use, and i will use less on the second trim to finish the second window. I've been trying for so long, but with no success. Thanks in advance.

11 replies

by fregeus

A = width of window
B = hight of window
C = number of windows

((A+B)x2)xC=D/144=E

E is you answer.

TCB

by tintoman

Except you can't have 2 "=" in your formula as that will cause a circular argument
the anser is
((A+B)x2)xC/144=D

by older mycroft

So, unless the trim is the thickness of a piece of thread, you DON'T have any excess left at all.

Because each corner has to be MITRED !! :^0

[i]The only EXCEL in this thread is the computer program - it's not the quality of your Window-Making for sure.[/i]

< sigh > Here - just in case you still don't understand ..

http://www.diydoctor.org.uk/projects/mitre.htm

[b]It's just as well M$ Windows doesn't fall apart as quickly as yours will !![b] :^0 :^0 :^0

by older mycroft

What on earth is the point of trying to figure out the calc, if the solution is totally impractable.

We've got a standard 24" x 36" working area to be 'trimmed'. Let's assume the 'trim' is 3" wide. Each edge of our 'trim' has to accomodate the trim width of the edge it meets (either TOP+BOTTOM or LEFT+RIGHT) - therefore each of the 4 'trims' MUST have 6" added onto its length to accomodate the mitres.

Even a Grumpy can figure that 4 x 6" = 24 inches.

The very same 24 inches this fool is going to SAVE for the next window in the sequence.

[i]Just in case you're thinking "[b]Ah - but what if the trim is only TWO inches wide! There'll be 8 inches to spare.[/b]" - It won't make much of a difference - because the offcuts are ALL mitred, so HALF of each offcut is unusable (cannot be buttressed to any other flat straight edge because it is diagonal).

Therefore no matter what width the 'trim' is, half of whatever is left cannot be re-used on another similarly-sized window.[/i]

The [b][i]MITRE[/b][/i] was introduced to the Western World by the Romans, after they stole it from the Egyptians.

Go complain to the Romans - they're a lot older than me and, by all accounts, a lot grumpier than me. :p

by tintoman

However you are loved for it on TR or so it seems to me
There is however one teeny weeny flaw in your theory about this, and that is that the person who posted this question stated from the start that it was PERIMETER measurements he was referring to, in that case the perimeter measurements are right for the calculation because the mitre cuts will cut inwards not outwards as you appear to be assuming.
I admit I didn't question the notion of re-using the material because he didn't tell us what it is and I have no idea if it can be invisible joined.
So now you agree with me right? (some hopes!!!)

by older mycroft

Silly me - there was me thinking "[i]around[/i]" meant that, whereas as you have just so graciously pointed out: AROUND actually means INSIDE.

Thanks for setting that straight (and angular). ;)

Y'see - I was assuming that "I've been trying for so long, but with no success." meant that he was sitting in the middle (not outside!) of a heap of debris that used to be windows.

Maybe I got that wrong too! :^0

by tintoman

not to buy any windows from him
interesting to note that he has bogged off and left us to remonstrate over his problem though.....
Incidentally i lifted this from wikipedia
"A perimeter is a path that surrounds an area. The word comes from the Greek peri (around) and meter (measure). The term may be used either for the path or its length"

In that case if you trim "around" a perimeter the perimeter moves outwards does it not?

This discussion is closed to new replies.