View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
SteveM SteveM is offline
external usenet poster
 
Posts: 133
Default out of memory problem! what to do for large matrix operations?

If it's for a commercial app, the MATLAB cost is incidental ($2,000)
compared to coding a from scratch level of effort.

An inexpensive alternative is embedding a C coded module into your app.
See Numerical Recipes in C (60 bucks.) It shows you how to code all
of the matrix math.

http://www.amazon.com/gp/product/052...lance&n=283155

Also talk to the algorithm guys at the OR newsgroup. They may be able
to supply you with references to some open source code for matrix math:

http://groups.google.com/group/sci.op-research

SteveM.

MCM wrote:
SteveM wrote:
What are you trying to do? Is this really a MATLAB problem? See:

http://www.mathworks.com/products/ma...ctionlist.html

SteveM




it is a numerical analysis code include some iterations. At every turn
for general loop it has to solve a linear equation set. I know that
some other software can be used but it is important to ose VBA excel
for this work. i.e. implementation of this kind of problem in VBA excel
is a part of the work. because some commercial reasons.

anyway thank you for suggestion.