Previous in Forum: Open Office   Next in Forum: Cloud Storage Proves It Is Worse Than Useless
Close
Close
Close
5 comments
Rate Comments: Nested
Power-User

Join Date: Feb 2011
Location: Shimurali, Westbengal,India
Posts: 119

Orthogonalisation Of A Matrix In VBA Excel

08/20/2014 6:39 AM

How I can compute Orthogonalisation of a matrix in VBA Excel 2007.

Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Guru
Engineering Fields - Electrical Engineering - Been there, done that. Engineering Fields - Control Engineering - New Member

Join Date: Dec 2008
Location: Long Island NY
Posts: 15600
Good Answers: 981
#1

Re: Orthogonalisation Of A Matrix In VBA Excel

08/20/2014 7:59 AM

To see if a square matrix is orthogonal will probably most easily be done with a series of tests that stop when the matrix is proven to be non-orthogonal. This is a pivotal concept in linear algebra that rightly deserves its own chapter in a text book, so translating this into a VBA program is outside the scope of this public engineering forum. This is particularly true since CR4 has a very good policy against doing homework. I agree with this policy but I will give you some hints. First test for all real numbers. Next take the determinant of the matrix. These two tests will quickly identify most non-orthogonal matrices. For proof of orthogonality convert to canonical form.

__________________
"Don't disturb my circles." translation of Archimedes last words
Register to Reply Score 1 for Good Answer
Guru
Hobbies - CNC - New Member Hobbies - DIY Welding - New Member Engineering Fields - Electromechanical Engineering - New Member

Join Date: Aug 2007
Posts: 23647
Good Answers: 420
#2
In reply to #1

Re: Orthogonalisation Of A Matrix In VBA Excel

08/20/2014 8:07 AM

have to say, very good and responsible response

__________________
“ When people get what they want, they are often surprised when they get what they deserve " - James Wood
Register to Reply
Guru
United Kingdom - Member - Not a New Member Hobbies - Musician - New Member Hobbies - Fishing - New Member

Join Date: May 2006
Location: Reading, Berkshire, UK. Going under cover.
Posts: 9684
Good Answers: 468
#3

Re: Orthogonalisation Of A Matrix In VBA Excel

08/20/2014 8:13 AM

Have a look in this document:

Macro Bundle Version 10

__________________
"Love justice, you who rule the world" - Dante Alighieri
Register to Reply Score 1 for Good Answer
Guru

Join Date: Mar 2011
Location: Sebastopol, California
Posts: 1205
Good Answers: 54
#4

Re: Orthogonalisation Of A Matrix In VBA Excel

08/20/2014 11:08 PM

You click your heals together and say, "There's no place like Orthogonalisation. There's no place like Orthogonalisation, There's no place like Orthogonalisatio." And away you go!

__________________
Most people are mostly good most of the time.
Register to Reply
Guru

Join Date: Oct 2006
Location: 44.56024"N 15.307971E
Posts: 8277
Good Answers: 270
#5

Re: Orthogonalisation Of A Matrix In VBA Excel

08/21/2014 7:47 AM

Use a Orthogonalisation calculator,available in your local university book store,

right beside element 115(UUP).

WDDHW (we don't do homework)!

__________________
"A man never stands so tall as when he stoops to help a child." "Never argue with a stupid person.They will drag you down to their level and beat you with experience" "To create an apple pie from scratch, first you must create a universe"
Register to Reply Score 1 for Off Topic
Register to Reply 5 comments

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Copy to Clipboard

Users who posted comments:

Deefburger (1); HiTekRedNek (1); JohnDG (1); phoenix911 (1); redfred (1)

Previous in Forum: Open Office   Next in Forum: Cloud Storage Proves It Is Worse Than Useless

Advertisement