Code Forums - View Single Post - Search -That Can Match Out Of Order Items

JBurke · 09-23-2003, 08:06 PM

Thanks sde.
I have the chord and scale table complete, and I have the main screen with the search box and macro buttons all layed out in MS Excel.
I have no problem directing a macro to return as follows:

User Search: A B C D E F#
Results 1: Chord-x A B C D E F#
Results 2: Chord-xx A B C D E
Results 3: Chord-xxx A B C D

But it will not find F# E D C B A (because the chord is inverted from the search). This is the critical issue. Sure, I could put in my table every possible inversion, but with scales that may contain 7 notes, the possible inversions are in the millions. Ok, maybe I could create a macro that could create strings in my table, like:
Chord-x F# E D C B A, E F# D C B A, E D F# C B A, E D C F# B A and on and on and on............
The macro could then find an exact match in the row (in the on and on and on...... part), then be directed to go to the first column of that long, long, long row and return the information contained there. Bingo.
But to do that for searchable strings of 7 notes with all possible inversions I would need 7x7x7x7x7x7x7=5,764,801 inversions. Is there a logic pattern that I could use to create macros to create these strings, or is there a better way? Or , is my logic of that many possible inversions way off in the first place? What programming tools would be best suited to get this thing working on the web, and how would it work, basically, with inverted chords?

Basically, I use MS Excel and Photoshop. I want to be able to get as much done myself before calling (paying) for the services of a programmer.

Thanks in advance.

Jim

09-23-2003, 08:06 PM	#4 (permalink)
JBurke Registered User Join Date: Sep 2003 Posts: 5	Thanks sde. I have the chord and scale table complete, and I have the main screen with the search box and macro buttons all layed out in MS Excel. I have no problem directing a macro to return as follows: User Search: A B C D E F# Results 1: Chord-x A B C D E F# Results 2: Chord-xx A B C D E Results 3: Chord-xxx A B C D But it will not find F# E D C B A (because the chord is inverted from the search). This is the critical issue. Sure, I could put in my table every possible inversion, but with scales that may contain 7 notes, the possible inversions are in the millions. Ok, maybe I could create a macro that could create strings in my table, like: Chord-x F# E D C B A, E F# D C B A, E D F# C B A, E D C F# B A and on and on and on............ The macro could then find an exact match in the row (in the on and on and on...... part), then be directed to go to the first column of that long, long, long row and return the information contained there. Bingo. But to do that for searchable strings of 7 notes with all possible inversions I would need 7x7x7x7x7x7x7=5,764,801 inversions. Is there a logic pattern that I could use to create macros to create these strings, or is there a better way? Or , is my logic of that many possible inversions way off in the first place? What programming tools would be best suited to get this thing working on the web, and how would it work, basically, with inverted chords? Basically, I use MS Excel and Photoshop. I want to be able to get as much done myself before calling (paying) for the services of a programmer. Thanks in advance. Jim