Skip to main content
D
DS_144523411-Visitor
1-Visitor
January 2, 2026
Question

Re: need help with iterative loop

  • January 2, 2026
  • 2 replies
  • 183 views

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

 

 

2 replies

W
Werner_E25-Diamond I
25-Diamond I
January 2, 2026
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.

    T
    21-Topaz II
    terryhendicott21-Topaz II
    21-Topaz II
    January 4, 2026

    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

     

    A
    anursinghCommunity Manager
    Community Manager
    March 9, 2026

    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 

    Terms & ConditionsCookie settingsAccessibility statement