E9 Copedant Note Changes Using VBA Code on Excel

[Ron Vandenberghe]

Many thanks to code guru (Stephen Crump) from Mr Excel for his help in making this work.
What it does: It reveals the notes across all 10 strings for any bar position while pressing any pedal and / or knee lever. The affected strings / notes are highlighted in colors.
How it works: Click a cell on the upper grid. The resulting notes are displayed on the lower grid.
How is it useful for steel players: It helps the player find intervals, inversions, grips, melody line notes and so on.
Here is the link to the macro enabled Excel file on Google Drive. I hope it proves to be helpful.
https://drive.google.com/file/d/1BFfPly ... drive_link
Steps: Click the link, download the file, right click the downloaded file, Properties, under the General tab check-mark the 'Unblock' box, Apply, OK.

[Derrick Phillips]

This is a great idea and something I was planning on doing ever since I got my U12, wanted to do it for the B6 (E lower) voicings.

When I click the link it says I need to request access. derrickfphillips@gmail.com has requested access.

Can you please approve it? Thank you!

[Brian Spratt]

Ron, this is pretty slick! Thank you for sharing it.

[Bill McCloskey]

I don't have excel. But I'd also recommend SteelSideKick app which provides a similar capability.

[John Larson]

Awesome, I had the idea to make something like this while driving the other day after reading about B0b's pedal steel slide rule he made back in the day. Looks like I can conserve my energy now.

[J D Sauser]

Interesting.
I downloaded it.

But I have a question: String #3, Fret #9 shows F#, while logic would suggest F-natural (fret #10 shows F# too)?

... J-D.

[Ron Vandenberghe]

Hi JD. Sorry for the delayed response. The cell in the upper grid representing the B pedal on the 9th fret was active which is the reason the 3rd and 6th strings showed F# on the 9th fret. When no cell representing the B pedal is active, the notes on the 3rd and 6th strings on the 9th fret show F natural.

[J D Sauser]

Hi JD. Sorry for the delayed response. The cell in the upper grid representing the B pedal on the 9th fret was active which is the reason the 3rd and 6th strings showed F# on the 9th fret. When no cell representing the B pedal is active, the notes on the 3rd and 6th strings on the 9th fret show F natural.

Thanks Ron, but I still don't understand why then it would show F# on BOTH the 9th and 10th fret(?).
Shouldn't having a change active change the notes along the string on ALL frets equally?

Maybe I am just doing something wrong... J-D.