Zdude:
It is not surprising that the stronger bolt will lead to a stronger connection and the same mode of failure AND more movement in the connection at design load. The higher Fy bolt material, given same bolt dia., and the bolt essentially acting as a cantilever beam with a point load from the 1/4" bracket pl.; the higher Fy allows a greater tip load and greater tip deflection before the bolt starts to yield. Except, the bolt is supported along its length by the wood bearing/crushing strength, akin to a beam on closely spaced spring supports of varying stiffness, and a lack of real end fixity. And, with the stronger (higher Fy) bolt, connection equilibrium will be reached with greater tip load (from the bracket), greater bolt tip deflection, and more joint movement. In effect, the various yield modes are an effort to represent these kinds of conditions.
Off the top of my head I don’t know, but does 90ksi = Fy for a grade 8 bolt? If it isn’t too much work, what with your spreadsheet and all, could you post all six of yield mode values, for 5/8" dia. and Fy = 45 & 90ksi. Could you do the same thing, for all six modes, for 3/4" dia. and Fy = 45 & 90ksi? This might be a bit of a learning moment for all of us (maybe just me), to start to get a feel for how dia. or Fy changes affect this problem. I don’t mean for you to ignore your wife &/or your girlfriend for the whole weekend to do this good deed. I don’t want to get you in trouble with both/either of them. Maybe I already have, and that I should have just been, ‘signif. others however many,’ including a pet if you wish.
In my old age, things sure seem to be getting complicated. Following all the code steps these days to design a single bolted connection, long hand, can take darn near a long as we used to spend on major parts of the whole building. We are really getting to complicated, having to include too much minutiae in every calc. and are really not producing better building for all the extra work. I wonder if we are saving the clients any money, saving materials, are designing significantly safer structures. I know we aren’t getting paid enough for the extra work and effort.
Thanks in advance for your effort.