Forum Discussion

mtarler's avatar
mtarler
Silver Contributor
Nov 29, 2022

Patrick2788 maybe I don't understand but I took a different approach and included the # notes.  First I defined the string sequence (going down the frets) and doubled the length to avoid dealing with wrap around:

 

 

 

={"E","F","F#","G","G#","A","A#","B","C","C#","D","D#","E","F","F#","G","G#","A","A#","B","C","C#","D","D#"}

 

 

 

then I did a lookup + offset:

 

 

 

=MAKEARRAY(11,12,LAMBDA(r,c,
           IF(ISODD(r),
                INDEX(strSeq,MATCH(INDEX(Strings,r),strSeq,0)+c),
                "")))

 

 

 

 

NOTE: if you want to specifically want to exclude the # notes then wrap a Let around it and add a statement like IF(len(pp)>1,"",pp) to blank out all the # notes.

 

EDIT: OK so I just figured out what you are doing.  you planned on using =FRET(STANDARD) as the formula to generate the grid and your FRET() function is basically identical to what I came up with.  So the only difference is that I created strSeq constant for STANDARD.  Literally I used =FRET(strSeq) and got the same result

 

🙂

EDIT2: OK so I'm guessing you're going to call foul on me because you say you only know "EBGDAE" and I created that constant with the # in it.  But I claim you can't possible create that STANDARD function with out knowing that sequence.

Resources