Skip to main content
DS_144523411-Visitor
1-Visitor
Jan 2, 2026 6:19 PM UTC
Question

Re: need help with iterative loop

I have: 

DS_14452341_0-1767377321814.png

 

And a dropdown with rebar properties:

DS_14452341_0-1767377742027.png

 

Areas are in col 2, 0.44, 0.60, 0.79, etc. How can I write an equation that returns the bar size with the largest area exceeding Areqd?

 

Please advise, thank you

 

 

3 replies

Werner_E
Werner_E25-Diamond I
25-Diamond I
Jan 2, 2026 9:56 PM UTC
How can I write an equation that returns the bar size with the largest area exceeding Areqd?

I guess you rather mean with the smallest area which still exceeds Areqd, right?

 

Unfortunately the dropdown is to be used just for manual selection.

Prime can't access all the data therein automatically.

You need the data in a data structure Prime can work with.

This can be a matrix consisting all the values or a series of individual vectors (nx1 matrices).

You must not but you can use a Prime table to input all the values.

Once the data is here its easy for Prime to select the row needed.

 

The attached sheet should help. Unless otherwise stated I assume that you are using the current version (11) of Prime.
In case you don't, I attach a pdf print for your information.

Translate
    terryhendicott
    terryhendicott21-Topaz II
    21-Topaz II
    Jan 4, 2026 1:46 PM UTC

    Hi,

    Selecting the grade has an influence on the area needed and the threads available for choice at that grade.

    Have added to Werner's great sheet:

    Two linked list boxes where you can choose the grade in the first list box and this dictates what shows in the second list box.  Choose in the second list box and it outputs the area.

    The first list box choice of grade is used to choose a suitable bar to match Area required (that varies by grade) and the chosen grade.

     

    New calculations are in the draft area off to the right.

     

    Cheers

    Terry

     

    Translate
    anursinghCommunity Manager
    Community Moderator
    Mar 9, 2026 4:47 PM UTC

    Hi @DS_14452341,

     

    I wanted to see if you got the help you needed.

    If so, please mark the appropriate reply as the Accepted Solution. It will help other members who may have the same question. 
    Of course, if you have more to share on your issue, please pursue the conversation. 

     

    Thanks,
    Anurag 

    Translate
    Terms & ConditionsAccessibility statement