Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

** Community Tip** - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page.
X

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Feb 16, 2022
12:15 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator

Feb 16, 2022
12:15 PM

Range return value

Hi guys Im getting this error below when looking at range of values in a table and trying to match the relevant density.

Sheet is attached, thanks guys

🙂

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

Feb 16, 2022
12:56 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator

Feb 16, 2022
12:56 PM

The error message is clear: linterp requires that the first argument is a vector with values in ascending order. Your vector Lv2 has values 1, 2, 4, 7, 0 and 0.

The first four values are ascending (every next value is higher than the previous), but the fifth and sixth are 0, that is less than 7.

Considering you have empty or zero values in that part of the table that you draw Lv2 from, I suggest you cut the bottom two lines (for layers 5 and 6) from the table. Then it should work.

Note that the result of the function is not 18, but 17.41 kg/m^3, because, contrary to its name, linterp also extrapolates linearly.

Success!

Luc

2 REPLIES 2

Feb 16, 2022
12:56 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator

Feb 16, 2022
12:56 PM

The error message is clear: linterp requires that the first argument is a vector with values in ascending order. Your vector Lv2 has values 1, 2, 4, 7, 0 and 0.

The first four values are ascending (every next value is higher than the previous), but the fifth and sixth are 0, that is less than 7.

Considering you have empty or zero values in that part of the table that you draw Lv2 from, I suggest you cut the bottom two lines (for layers 5 and 6) from the table. Then it should work.

Note that the result of the function is not 18, but 17.41 kg/m^3, because, contrary to its name, linterp also extrapolates linearly.

Success!

Luc

Feb 16, 2022
03:47 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator

Feb 16, 2022
03:47 PM

Thanks Luc thats spot on, yes changed the values in the table and it returned 17.41 kg/m^3.

Yes correct Luc, i have swapped the Interp out to get