Forum Discussion
Formula Challenge: Create a guitar fretboard diagram
This exercise has helped in my ongoing studies of Excel and learning acoustic guitar. The challenge is to produce the standard tuning (E-A-D-G-B-E) diagram: [This diagram lists 'natural' n...
The average calc time was .00081 for this version.
Re: the previous version
I did some testing with MATCH/XMATCH with the lookup vector being about 95,000 unique elements. At first, I did a simple match of one number that was in the first position in the array - no difference in calc times. Next, I picked the last element and again no real difference in calc times. Finally, I pulled 100 items from the lookup array to be matched and spilled XMATCH/MATCH and again no real difference in calc times.
Re: the previous version
I did some testing with MATCH/XMATCH with the lookup vector being about 95,000 unique elements. At first, I did a simple match of one number that was in the first position in the array - no difference in calc times. Next, I picked the last element and again no real difference in calc times. Finally, I pulled 100 items from the lookup array to be matched and spilled XMATCH/MATCH and again no real difference in calc times.
Patrick2788OK let's see if we can trim some time by removing LAMBDA:
using textjoin/textsplit:
=TEXTSPLIT(
TEXTJOIN(";",FALSE,
IF(Strings<>"",
MID(Scale,SEARCH(Strings&",",Scale)+LEN(Strings&","),28),
REPT(",",11))),
",",";")going 'old school' except SEQUENCE:
=TRIM(IF(Strings<>"",
MID(
SUBSTITUTE(MID(Scale,SEARCH(Strings&",",Scale)+LEN(Strings&","),28),",",REPT(" ",28)),
SEQUENCE(,12,,28),28),
MID("",SEQUENCE(,12),1)))