Wow, Jim! I really appreciate your long response and for sharing all your work. Looks like you have a great plan for your build!
I also have a quite involved spreadsheet with dyno plots, gear ratios and tractive effort curves, letting me get the most out of the engine and gears. All of that is thanks to the previous owner, who was my Vehicle Dynamics prof!
The tractive effort curves show me the optimal shift points, based on the force available at the wheels. The "perfect" shift is when your tractive effort matches with the gear you're upshifting to.
Luckily enough, these engines are internally balanced and resilient to 1st, 2nd, and 3rd order harmonics. Gotta love straight-sixes! As you've implied, the crank and clutch will be balanced individually, and the pistons and rods will be weighed to make sure they match each other. Looking forward to seeing you work and meeting sometime! Thanks again, Jim.