On 11/13/2009 9:13:08 AM, Armo wrote:
I have attached a sheet which extracts pipe lengths from a excel component and calculates the total lengths of each pipe string.
I have used the Submatrix function which I find messy and confusing to a none Mathcad user.
Would there be a better way of handling the data extracted from the excel component and not using the Submatrix function?
Could you explain a little further why you've chosen the format you have? (eg, using nonzeros to limit the number of elements extracted).
As far as I can tell, simply using the column operator directly should achieve what you want - the overhead of summing the zero elements is probably less than the performance decrease by using nonzeros.
Stuart