I would say, just looking at it, your Excel spreadsheet only allows for four values. So, how do you exspect to get more out of it?

No, it's not. because i already tried revising the output range in the excel file to include even 6 pedestals. i doubted the settings of the total number of loads. but i have no idea how this relates to the overall matrix formulation.

Yes, it is. See attached.

• http://files.engineering.com/getfile.aspx?folder=41976d2c-2904-4f30-b637-b7

Thanks for your response Occupant. But Final MatrixLoad has no result, this was my problem. one of the error is "This array has an incorrect number of rows and column"

MathCAD also has a limit to how big a matrix can get... might be having a hissy if you're getting too large.

look into making the output an excel file or a CSV.

Yes, its quite big around 9 x 29 for 1 pedestal, 9 x 116 for 4 pedestals, that is 29 rows (for load comb) will be added for each pedestal added to the matrix.

But i even tried reducing the number of load combination to only 3 (from 29 orig), the matrix size is 9 x 9 for 3 pedestals, 9 x 12 for 4 pedestals and still the error occur in 4 pedestals.

Your Excel insets don't appear to be correctly inserted in the sheets. They all should have something along the lines of:

XY:={Excel}

You should be using Insert Component | Excel Worksheet, which should give you almost the exact same thing, except for the empty placeholder to the left of a := next to the component.

TTFN
FAQ731-376: Eng-Tips.com Forum Policies

Excel was embeded as component, please see attached with arguments shown for each excel sheet.

• http://files.engineering.com/getfile.aspx?folder=f1b50634-15b3-469d-9c7f-08

No, I think, you're just being sloppy. Look at attached - green color. I stopped there - otherwise it looks like work and who wants that?

• http://files.engineering.com/getfile.aspx?folder=063ee410-f408-4f1e-9c0f-ac

Sorry Occupant but, i did the review of your attached file and the error is still there. Please take a look on the attached PDF file. I made a comparison between 3 pedestals which gave the MatrixLoad as shown in Page 5 of 10, and with 4 Pedestals which returned first error on page 9 of 10, and eventually Page 10 of 10 is blank.

I am sure its not on the size of Matrix, because i already tried reducing NoOfComb from 29 to 3, but the error is still there.

• http://files.engineering.com/getfile.aspx?folder=b84932fa-82c6-4d1a-be66-52

Let's see if I got this right You want in the end to wind up with a matrix called MatrixCombFactor size:115x7 (assuming 4 pedestals) and each field in that matrix again holding a matrix 29x28 to cover all combinations?

I found the error guys, it is on the multiplication of the following lines:
CombFactor*submatrix(MatrixLoad,NoOfLoad*k,NoOfLoad(k+1)-1,0,NoOfForce-1)

- The difference between NoOfLoad(k+1)-1] - [NoOfLoad*k] should be equal to the number of loads, (i.e NoOfLoad-1 to account 0, so i change the formula:
CombFactor*submatrix(MatrixLoad,0,NoOfLoad-1,0,NoOfForce-1) and it ran as i expected!