COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### "circle" use datas from Excel sheet

• Email
• Follow

```Hello again !

I have a problem with matrix and operations. I have 3 matrix which have different length :

matrix1=59999
matrix2=59998
matrix3=59998

Of course when I want to make operations on them it doesn't work because they don't have the same length.

These matrix are generated from from an Excel sheet which contains 60'000 rows.

What I want to do is to force the calculation of the matrix to use the first values of the Excel sheet. For example, I have to subtract 2 rows :

59997-59996
59998-59997
59999-59998
60000-59999

And then it stops, but I want to continue to do calculations following this plan :

59997-59996
59998-59997
59999-59998
60000-59999
00001-60000

And applying that principle to the other matrix I could get the same length for all 3 and make calculations !

Any help is welcome to solve this problem ! :-)
```
 0
Reply mathieu.horsky (76) 6/12/2012 7:54:06 PM

See related articles to this posting

0 Replies
44 Views

Similar Articles

12/6/2013 1:13:29 AM
page loaded in 31442 ms. (0)