MUSC 108. Introduction to Music Technology - Fall 2013

[Overview] [Syllabus]

04Lab4 - Create Voice Two

Copy all Voice 1 data from 04Lab3 and paste it into 04Lab4.

  Measure 1 Measure 5 Measure 9 Measure 13 Measure 17 Measure 21
Chorus 1
Chorus 2 (Repeat of Chorus 1)
04Lab3 voice 1 begins     voice 1 repeats    
04lab4   voice 2 begins     voice 2 repeats  
04Lab5     voice 3 begins     voice 3 repeats

Compute The Starting Time For Voice 2

Voice 2 starts when Voice 1 is at measure 5. Measure 5 begins at time 17000 ((4 measures * 4 beats * 1000 ms) + 1000 ms). If you add 16000 to all Voice 1 times, voice 2 will start at 17000, the beginning of measure 5.

Enter this formula in E2: =A2+16000

Copy to remaining cells in column E and Paste Special by Values into A2.

Voice 2 Is On MIDI Channel 2

Change voice 2 to MIDI channel 2.

Select all of Column B by clicking on the B. As long a column B is selected the find and replace will be confined to column B. Choose Replace from the Edit menu. When the Find dialog opens, click the Replace button. Make sure "Find entire cells only" is checked. Find 90 and replace with 91.

Excel Replace dialog

Repeat to replace 80 with 81.

Repeat to replace B0 with B1.

Save

Continue with 04Lab5.

[Overview] [Syllabus]

Revised John Ellinger, January - September 2013