RE: calculate blocks contained in a larger piece of wood
- From: "GS" <GS@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 26 Feb 2006 10:37:29 -0800
Hi St Art,
I'm glad to be of help. Thanks for the feedback!
Since you always have 3 dimensions to work with in your material stock, the
formulas will be easier to construct. It seems you're looking for the maximum
yield, so it would be easier if you don't try to account for the leftovers in
your yield calculations. Just recycle them if you can live with that.
If you call me mentioning "orientation" in my previous reply, it's a very
important aspect of the "equation". Visualization is the key. You have to be
able to "visualize" in 3D to determine the maximum yield. For example, the
way I explained it, I went on my natural instinct as to how the pieces should
be oriented within the envelope of your material stock. Fortunately, I was
correct. Any other orientation would have yielded fewer pieces. I verified
this later using solid modelling CAD software. I was able to manually place
each item inside a transparent container representing your material stock. To
have the software do this automatically requires inputting "equations" so it
can make all the necessary calculations to create the different combinations
possible. The "equations" are simply formulas than refer to the three
dimensions, and include the "spacing" between each of item. The "spacing" is
the equivalent to "cut allowance", which your formula ("equation") must be
flexible enough to not include if not needed. For example, the last six
pieces in my example each yield 3 items. Only 2 of them have cut allowance,
as follows:
|<------ 4.750" ------>|
- - - - - - - - - - - - - - - - -
Item[cut]Item[cut]Item 'assumes [cut]=0.125"
- - - - - - - - - - - - - - - - -
1.500+.125+1.500+.125+1.500 = 4.750
The equation would be: =(Item*3)+(cut*2)
You will need to wrap it in an IF() that checks if the 'z' dimension of
Material Stock requires all three cut allowances, indicating a leftover
piece. This would depend on the Yield Item's dim value for 'z'. You could
capture this using MOD() with the 'z' dims as arguments. Don't forget to
include the cut allowance in Item's 'z' value.
** Suggestion: Use named formulas.
This makes understanding your in-cell formulas easier.
You'll need to use POWER() and PI() for area and volume calculations for
both.
You could have these readily available using named formulas. **
Each possible orientation "configuration" (or combination) would have to be
calculated separately to show all the possible results. If you construct your
spreadsheet to require input cells for each material stock dimension, for
each item dimension, and one for cut allowance, you can enter formulas in
other range areas to calculate all possibilities and choose the one you want.
Here's what I mean:
Material Stock Item Yield
x y z x y z
---------------------------------------------------------------
S W L S W L 'formula
goes here
L S W "
W L S "
This orients Item to x=S, y=W, z=L of Material Stock for each dimension
orientation of Item.
Include range areas as follows for each orientation combination:
L S W ... 'and so on... to orient to x=L, y=S,
z=W
| | |--where cell W's formula is: =MaterialWidth
| |-------where cell S's formula is: =MaterialSize
|------------where cell L's formula is: =MaterialLength
Repeat for:
W L S ... 'and so on... to orient to x=W, y=L,
z=S
********************************************
A note about "Item" and "Material Stock" dimensions:
********************************************
1. If any two dims for either are equal, two of each three sets of results
will be the same.
2. If all three dims for either are equal, all results will be the same.
Given that there are 6 sides to each, 2 of each of those are equal if the
pieces are rectangular. This includes square blocks, which are actually
rectangles with all sides equal.
I hope this helps give you a little more to go on. Best of Luck!
Garry
"St Art" wrote:
Hi GS
I was having trouble visualizing the process but you explained it very well.
as i will always have length, width and thickness on the wood i have, it was
fairly straight forward to work out a process to give me the total pieces
that i can get from a piece of wood. but you're right...trying to figure out
the leftovers will be the hard part...i'll work on it
thanks for your help
St Art
.
- References:
- Prev by Date: Re: Extract filter items from Drop-Down Automatic Filter
- Next by Date: Workbook Event
- Previous by thread: RE: calculate blocks contained in a larger piece of wood
- Next by thread: Re: group method - is there a collection
- Index(es):
Relevant Pages
|
