How do you use Microsoft Excel to create a 12 tone matrix?

Answer:

Inversion is easy, retrograde not so easy. Say your 12 numbers are in A1 to A12. In B1 type =13-A1 and drag this formula across the row to B12. Your number 0 becomes 13, this is because it is an octave higher. This formula will work for any sequence. Retrograde would involve referencing cells - this is a bit of a cheat. In 3A type:- =INDIRECT(CHAR(77-COLUMN())&"1") and drag across. The inversion, in row 4, is =13-A3

We Walk Aløne at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

Inversion is easy, retrograde not so easy. Say your 12 numbers are in A1 to A12. In B1 type =13-A1 and drag this formula across the row to B12. Your number 0 becomes 13, this is because it is an octave higher. This formula will work for any sequence. Retrograde would involve referencing cells - this is a bit of a cheat. In 3A type:- =INDIRECT(CHAR(77-COLUMN())&"1") and drag across. The inversion, in row 4, is =13-A3

Andrew L

This Site Might Help You. RE: How do you use Microsoft Excel to create a 12 tone matrix? For instance if I typed in my row P0 1-5-3-2-6-8-7-9-4-10-11 how could I make it calculate the inversion, retrograde, and retrograde inversion?

Related Q & A:

How do I use Microsoft Word to open a Google Drive cloud document?Best solution by Quora
How do you use the Blackberry storm as a wireless modem?Best solution by Yahoo! Answers
How do i use my aiptek camcorder as a webcam?Best solution by Yahoo! Answers
How can I use my digital camera as a webcam?Best solution by Yahoo! Answers
How do I use Microsoft Outlook Express?Best solution by eHow old

Just Added Q & A:

How many active mobile subscribers are there in China?Best solution by Quora
How to find the right vacation?Best solution by bookit.com
How To Make Your Own Primer?Best solution by thekrazycouponlady.com
How do you get the domain & range?Best solution by ChaCha
How do you open pop up blockers?Best solution by Yahoo! Answers

For every problem there is a solution! Proved by Solucija.

Got an issue and looking for advice?
Ask Solucija to search every corner of the Web for help.
Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.