Hi Simon,

Find the file attached.

Brief discription what the workbook actually contains.
The worksheet contains a bending schedule which is used on site and
steel suppliers use it to fabricate the order. In structural concrete
work you use reinforcing steel, this steel is bend in certain shape
depending on it's purpose/shape of the concrete work. All standard
shapes have a shape code with coresponding formula to calculate the
actual cut length before bending the steel into the shape needed. In the
case of reinforcing steel there two types (type R and Y), type R is
slightly more flexible as type Y and therefore has sharper bends, hooks
etc. Besides the type of steel the diameter determines the bends as
well.

The big challange in my sheet is the calculation of the cut length
(marked in red), it would be nice to use a small simple lookup table
what I have in the current sheet. I would like excel to return the
formula and not a result. As said in my previous mail it seems like I
have to create a big table and mirror the rows from the bending shedule
(sheet1) with the rows on sheet2 and write the formula for each possible
shape code. This way I could actually return a result. For now I'm
focussing to make this work with the simple formulas (the completed
ones) the other formulas are more complex and need index/vlookup values
within the formula, these I will try and sort out ones I have this
working.

Thanks,

WillemBlink1

PS All my post on the forum refer to this worksheet at this stage. Nice
project for me to sort out.


+-------------------------------------------------------------------+
|Filename: Bending Schedule.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=139|
+-------------------------------------------------------------------+

--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96571