This forum thread will track of the version history of the following download:
BMREINF9.xls

In the "BMREINF9.xls" workbook, in the "Member + WT" worksheet a "quirk" was discovered for situations where the neutral axis of the composite section falls below the bottom of the existing member. These are not situations which would often occur, but in theory they can and when they do, the composite section modulus referenced to the bottom of the lower flange of the existing member would come out to be a negative number as it was programmed. Corrections were made by merely inserting the absolute value command (ABS) where required. Again, these situations are not practical as they entail adding reinforcement which is basically more hefty that the original member. For these situations if the normally high residual stress is included, as it should be unless the original beam can be virtually unloaded, the heavy reinforcing section does not buy you much at all. Nevertheless, since this worksheet could be also be used with the assumption of unloading the original beam, I have made the corrections as noted above. The same corrections were also made in the "Member + Plate" and "Member + I-Beam" worksheets. This workbook is now version 1.8.

After all of these years in working on very my first all metric units project (haven't I been fortunate) the past several months, we in the group have been making use of the "BEAMCOL9.xls", "BMREINF9.xls", and BASEPLT9.xls" spreadsheet workbooks. We also have been working with structural steel with a de-rated yield stress value. Thus, I removed the input data validation pick boxes which originally limited the user to specific values of 'Fy', 33 (old steel), 36, and 50 ksi. I also added the "ROUND" command to the sketches which displayed the member dimensions, to truncate the display of the member dimensions (d, tw, bf, and tf) in case they were converted by formula from metric to English. I merely wanted to make these workbooks a bit more "friendly" toward metric units usage.

By the way for us ASD 9th Edition "die-hards", the "BeamCol(Built-Up)" worksheet is a useful tool for doing AISC Code checks using metric shapes, in that all you need to do is enter a formula in the input cells for each of the dimensions (d, tw, bf, and tf) in millimeters divided by 25.4, and the worksheet will automatically calculate all of the properties for you. Keep in mind that the "fillets" of the member are not considered, so the calculated properties will be very close approximations.