Skip to main content
dpreston1-Visitor
1-Visitor
May 18, 2015 11:34 PM UTC
Solved

Find Function and an Array

I have two arrays I want to use with a find function. I'm having difficulty getting it to work. Any easy advice? See the clip of the spreadsheet below. The arrays are "t" for plate thickness and "a" for the plate radius. As you can see the definition is just passing through the find function. This is a Roarks workbook copied and pasted into a spreadsheet - Table 24A case 3. Thanks for any assistance. This is M'cad 15.

dprestonAnswer
1-Visitor
May 19, 2015 11:12 PM UTC

I solved the issue. So nvrmnd. Thanks again.

View in thread

8 replies

RichardJ19-Tanzanite
19-Tanzanite
May 19, 2015 12:04 AM UTC

You need to make the solve block a function of the variables you wish to change.

YMAX(a,t):=Find(ymax).

Then call the function YMAX for whatever values of a and t you wish.

If that information is not enough for you to get it working (which is quite likely!), could you please post a worksheet.

Translate
dpreston1-VisitorAuthor
1-Visitor
May 19, 2015 2:27 PM UTC

RJ...not having any luck with your suggestion but I may not fully understand my options and the rules. I'm also not seeing an option to upload the worksheet to this discussion topic. I will upload when I determine just how to do the upload.

Translate
RichardJ19-Tanzanite
19-Tanzanite
May 19, 2015 3:34 PM UTC

In the edit dialog click on "Use advanced editor" at the upper right. You do not see this when replying directly from your inbox, so you need to go to the dicussion thread and reply from there.

Translate
dpreston1-VisitorAuthor
1-Visitor
May 19, 2015 8:07 PM UTC

Please see the attached file for consideration. Note I have been "fiddling" with this for quite some time now. I have been attempting to directly followed a "Help" quicksheet and still no solution. My solution looks to follow the example too. See the example below. Thanks again for the assistance.

Translate
RichardJ19-Tanzanite
19-Tanzanite
May 19, 2015 10:47 PM UTC

Get rid of the subscripts in the solve block. The variables are aa and tt. That's all you need to define the function. Different values are passed to the function after you have defined it, not when you define it.

Also see my other comments.

Translate
dpreston1-VisitorAuthorAnswer
1-Visitor
May 19, 2015 11:12 PM UTC

I solved the issue. So nvrmnd. Thanks again.

Translate
RichardJ19-Tanzanite
19-Tanzanite
May 19, 2015 11:37 PM UTC

So nvrmnd.

Too late

Translate
Terms & ConditionsAccessibility statement