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...
it appears you reversed your imp and met in the call in the cell:
=MAP(E2#,imp,met,Imperial)
should be
=MAP(E2#,met,imp,Imperial)
=MAP(E2#,imp,met,Imperial)
should be
=MAP(E2#,met,imp,Imperial)
Good catch. I was testing the order of the arrays and forgot to switch it back.
Your latest version w/o Lambda: .00088 average calc time
Your latest version w/o Lambda: .00088 average calc time
- which one I had 2 in that file (& post) or did they each perform the same?
- That was for the top one. The bottom solution clocked in at .00083 (Average of 5 timings).