Forum Discussion
Patrick2788
Nov 29, 2022Silver Contributor
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...
mtarler
Nov 30, 2022Silver Contributor
yes I too have had some dreadful HTML error issues. I wonder what changed.
PeterBartholomew1
Nov 30, 2022Silver Contributor
I will try to post a code snippet.
Another place where arguments are read from left to right is Curried functions
= LAMBDA(x,LAMBDA(y,LAMBDA(z, (x+y)/z)))(3)(5)(2)
gives
= (3+5)/2 = 4
or, with naming,
CurriedLambda
= LAMBDA(x,LAMBDA(y,LAMBDA(z, (x+y)/z)))
= CurriedLambda(3)(5)(2) also gives 4
The final parameter can also be provided by a helper function
= MAP({2;3;4}, CurriedLambda(3)(5))
gives
= {4.00; 2.67; 2.00}
- PeterBartholomew1Nov 30, 2022Silver ContributorSeems to work. I don't know what was happening before.
- mtarlerDec 01, 2022Silver Contributor
Patrick2788 OK I have 2 more variations:
=IFERROR(INDEX(strSeq,,SEQUENCE(,12)+XMATCH(Strings,strSeq)),"") =IF(Strings<>"",INDEX(strSeq,,SEQUENCE(,12)+XMATCH(Strings,strSeq)),"")
I'm betting on the 1st ...
- Patrick2788Dec 01, 2022Silver ContributorTimings: .00087 and .00084
I re-ran the calc timings removing the IFERROR and IF, respectively and the timings were about the same.