Skip to main content
D
dpreston1-Visitor
1-Visitor
May 18, 2015
Solved

Find Function and an Array

  • May 18, 2015
  • 3 replies
  • 3865 views

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.

Best answer by dpreston

I solved the issue. So nvrmnd. Thanks again.

3 replies

R
RichardJ19-Tanzanite
19-Tanzanite
May 19, 2015

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.

D
dpreston1-VisitorAuthor
1-Visitor
May 19, 2015

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.

R
RichardJ19-Tanzanite
19-Tanzanite
May 19, 2015

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.

D
dpreston1-VisitorAuthor
1-Visitor
May 19, 2015

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.

R
RichardJ19-Tanzanite
19-Tanzanite
May 19, 2015

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.

D
dpreston1-VisitorAuthorAnswer
1-Visitor
May 19, 2015

I solved the issue. So nvrmnd. Thanks again.

R
RichardJ19-Tanzanite
19-Tanzanite
May 19, 2015

So nvrmnd.

Too late

Terms & ConditionsCookie settingsAccessibility statement