Skip to main content
fahmed-214-Alexandrite
14-Alexandrite
Jul 28, 2025 5:32 PM UTC
Solved

Array Index Invalid

Hello,

 

I am trying to build a Mathcad sheet to find pile capacity. The maximum number of soil layers available is nine (9). The user can choose to use all or, some of the layers within this 9. I am trying to build a logic to assign unit weight based on the layers I have subdivided to. The issue is if all layers are not being inputted, then the logic for unit weight says "Array Index invalid". Please help on this issue, my version is Prime 10.

fahmed2_0-1753723909676.png

 

Thanks

terryhendicott
terryhendicottAnswer
21-Topaz II
Jul 29, 2025 1:41 AM UTC

Sorry attached file was version 11

here is version 10

Cheers

Terry 

View in thread

8 replies

terryhendicott
terryhendicott21-Topaz II
21-Topaz II
Jul 28, 2025 11:32 PM UTC

Hi,

I suggest an input table like this:- 

Capture5.JPG

Capture.JPG

 

Saves the steps turning input into vectors as the table creates them.

Rows for less or more layers in a problem can be easily adjusted and sheet corresponds to these changes using last()

Capture2.JPG

Assigning depths of the layers is trivial

Capture3.JPG

As is finding the layer the pile stops in

Capture4.jpg

Cheers

Terry

Translate
ttokoro
ttokoro21-Topaz I
21-Topaz I
Jul 28, 2025 11:35 PM UTC

l is only 0 to 2 index. So use Try on error and get below result.

 

 

image.pngimage.pngimage.pngimage.pngimage.pngimage.png

Translate
t.t.
terryhendicott
terryhendicott21-Topaz II
21-Topaz II
Jul 29, 2025 1:24 AM UTC

Hi,

Now for the second part getting the value of Gamma.

Setting the water table in the depth of the pile for demonstration.

Capture.JPG

Gets the following Gamma

Capture2.JPG

Cheers

Terry

Translate
terryhendicott
terryhendicott21-Topaz IIAnswer
21-Topaz II
Jul 29, 2025 1:41 AM UTC

Sorry attached file was version 11

here is version 10

Cheers

Terry 

Translate
    Terms & ConditionsAccessibility statement