Home > Software engineering >  Excel macro inside the VB programming
Excel macro inside the VB programming

Time:10-19

If there is a line ten columns of sparse matrix if one line 9 9 columns have a number of 8 then can simplify in the excel table, such as

The said line only ninth in the sparse matrix column elements of 8, 9 other elements of 0

Now there are two such sparse matrix, count them, the product of matrix can literally written, but if after reduction of form, the output is also after reduction, in the form of VB how to write the program,,,,,,,,,
[nasty cry really very urgent KouXie]

I will only simple for loop and an if statement

CodePudding user response:

Halo, that if 10 x 10 matrix, a total of 100 number,
You only have a very special examples, if other conditions, how to "simplified representation"?
Every matrix, don't you only one non-zero value?


For example, there are 29 non-zero values, there were a few values are repeated...

And, what's up "sparse matrix", the so many 0, "multiply" as a result, like is basically the variable 0?

CodePudding user response:

Sparse matrix??? The word seems to have no impression, don't know who once studied or back... Ah, too old
  • Related