--bcaec53f908d6f08fb04a00963bd Content-Type: text/plain; charset=ISO-8859-1 On Sun, Apr 3, 2011 at 1:44 PM, Mike Stephens <rubfor / recitel.net> wrote: > Phillip Gawlowski wrote in post #990664: > > > Anecdote: > > My EE prof used Excel to invert a matrix. Took about 30 minutes, and > > was far from obvious (I forgot how it was done, since it was > > definitely something Excel wasn't designed to do), when a specialized > > tool (Maple in this case), did the same job in one line of code, > > following the mathematical notation (M_inverse : ^-1). > > Would that remark still apply if Excel had - let's say - a function > MINVERSE() - a similar single line of code? > > Well, interestingly, I do believe it does. > > Have a look at eg > http://www.chem.mtu.edu/~tbco/cm3450/Excel_Array_Formulas.pdf > > I suspect people don't realise what power Excel has, because hardly > anyone talks about it. They either talk about everyday corporate number > crunching or conventional programming lnaguages. Few people think about > taking Excel's components and mixing them together to solve > simultanaeous linear equations. > > -- > Posted via http://www.ruby-forum.com/. > > Hmm, when you post, it fragments into a new thread in my gmail. I assume because you change the subject. I'm trying to figure out how to fix it ( http://www.google.com/support/forum/p/gmail/thread?tidca2a74c9f70e02d) but doesn't look like it will happen any time soon. Meanwhile, I'd be appreciative if you could just make the new subject be "Re: #{original_subject}" (musing: I wonder how ruby-forum knows they are part of the same thread.) --bcaec53f908d6f08fb04a00963bd--