Automating the selection of steel reinforcement in a concrete slab

[BWilliams23]

I am trying to automate the process of determining the size and spacing of steel reinforcement in a concrete slab. My outputs need to be 'Bar size' and 'Bar spacing'.

I need to choose the smallest value of cells ( E91:E99 ) which will then output the corresponding value in cells ( F91: F99). I have accomplished this using INDEX(F 91: F99 ,MATCH(MIN( E 91 : E99 ), E 91:E99,0)).

The problem is that there is a maximum allowable Bar spacing based on other variables. So the output of the above equation needs to be less than the maximum (located in B104)

i.e. INDEX(F91:F99,MATCH(MIN(E91:E99),E91:E99,0))< B104

In summary, the program should be able to choose the smallest area of steel (A_s) while making sure that the corresponding spacing does not exceed the max allowable spacing.The output must be the spacing that satisfies this as well as the bar size that corresponds to that spacing.

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[JeteMc]

I completely agree with Pepe.
That said you might try the following: =INDEX(F91:F99,AGGREGATE(15,6,E91:E99/(F91:F99< B104),1))
Let us know if you have any questions.