Put in all I have so far - definitely messy! But at least the info will be available.
I made it a point to label Excel as being for the Mac and the 2011 version. If anyone has the newest one and is willing to go all through this, that would probably make a better default so if anyone wants the job, let me know!
One thing that testers may want to do is create a layout just for testing this. I have two slots for my iMac. One is for all my normal stuff. The other will usually be for when I want to use my media focused setup I posted here before. But for now I have this special testing layout for any weird thing I need to do.
You may notice that a sot of my spreadsheet is set up in groups of 6. This is because they are referring to the main layer key on the left (Q) for the first item. The next row is the same letter key, but with the space bar down (green layer). These two pairs are typically related - in this case, Backspace and Forward Delete.
The next two are for next letter down (A). First the main layer and then the green layer. Once again, they are related (Delete Previous Word and Delete Next Word).
Same with the next letter down (Z). So that usually gives us a set of 6 before I go to the next column of letters on the keyboard (WSX), giving me six more items.
So, if you are willing to take the time to change the contents of those two layers, it makes testing much easier - though still a big pain. At least for me.
I have, hopefully successfully, “protected” the first two columns since, hopefully, they are done. If you find an error (I found a couple as I was entering the info), just let me know so I can correct it.