ChordRandomizer.xlsm (15.4 KB)
Not really sure where to put this, so if this isn’t the place, please move it.
I wanted a tool to randomize chords and spit them back at me one at a time. I was surprised that I couldn’t find an app for that (maybe there’s some money to be made there.) Anyway, I never learned to code for iOS or Android, but I have some rudimentary XL skills, so I threw this together.
Here’s what I was thinking. There are 3 variations of chords in this version of the file; Majors, Minors, and 7ths. When you open the spreadsheet, it may ask you if you want to enable Macros. You have to allow Macros for it to work. Down at the bottom right, there’s a “Pause Time” cell. Changing that time changes how long you have between chord changes. I’m thinking I’ll start with the “Y” (or 1) position and start hitting every spot on the neck for the named chord using that position. Then I’ll speed up the pause time until I can land on each chord without having to think about it. Then I’ll do the same for the X (or 2) position, then the bar (or 3) position.
From there, I’ll branch out to the minors in all 3 positions, and finally the 7ths. You get the idea. Now that I think about it, I can see another version of this file where the randomizer also names which hand position to hold for the chord, and also even mixing up the majors, minors, and 7ths. I’m thinking the ultimate goal is to have the randomizer throw all chord variations and hand positions at me without separating them out.
@Archie, you had some good input on this subject. If you have Excel, I’d be interested in your input.