REBARS (318M-05).xls

"REBARS" is a spreadsheet program written in MS-Excel for the purpose of determining reinforcing bar development and splice lengths.  Specifically, the development lengths and splice lengths for straight bars in tension as well as compression are determined.  Also, the development length for standard hook bars is determined.  The provisions for development and splice lengths are included for high seismic risk applications per ACI 318M-05, Chapter 21.  There is also a worksheet which contains reinforcing bar data tables. This METRIC version is based on the ACI 318M-05 Code.
This program is a workbook consisting of five (5) worksheets, described as follows:

• Doc
• Calc Development (Soft Metric)
• Calc Development (Euro Metric)
• Rebar Data (Soft Metric)
• Rebar Data (Euro Metric)

Program Assumptions and Limitations:
1.  This program follows the procedures and guidelines of the ACI 318M-05 Building Code, Chapters 12 and 21.
2.  The "Calc Development (Soft Metric)" worksheet, for a given reinforcing bar size, determines the straight development and splice lengths for a "top" bar and an "other" bar in tension, the straight development and splice lengths for the bar in compression, and the tension development length of the bar as a standard hook, all at one time.  A complete table of reinforcing bar development and splice lengths is also created.
3.  The ACI "Soft Metric" reinforcing bar sizes are #10, #13, #16, #19, #22, #25, #29, #32, #36, #43, and #57. These correspond directly to the U.S. bar sizes #3, #4, #5, #6, #7, #8, #9, #10, #11, #14, and #18, as the bar designations represent the exact metric conversion of bar diameter rounded to the nearest whole millimeter.
4.  The "Calc Development (Euro Metric)" worksheet, for a given reinforcing bar size, determines the straight development and splice lengths for a "top" bar and an "other" bar in tension, the straight development and splice lengths for the bar in compression, and the tension development length of the bar as a standard hook, all at one time.  A complete table of reinforcing bar development and splice lengths is also created. This worksheet can be utilized for cases where the design concrete code used is ACI 318-05, but where the reinforcing bars to be provided are European (British Standard) bar sizes, not U.S. bar sizes.
5.  The "European Metric" reinforcing bar sizes are D6, D8, D10, D12, D14, D16, D20, D25, D28, D32, D40, and D50.  These do not correspond directly to the U.S. bar sizes nor to the "Soft Metric" bar sizes, as the bar designations represent the exact bar diameter expressed in millimeters.    
6.  The "Rebar Data (Soft Metric)" worksheet contains two tables of reinforcing bar data which include various bar properties as well as reinforcing bar areas based on spacing using units of mm^2/m.
7.  The "Rebar Data (Euro Metric)" worksheet contains two tables of reinforcing bar data which include various bar properties as well as reinforcing bar areas based on spacing using units of mm^2/m.
8.  This program contains numerous “comment boxes” which contain a wide variety of information including explanations of input or output items, equations used, data tables, etc.  (Note:  presence of a “comment box” is denoted by a “red triangle” in the upper right-hand corner of a cell.  Merely move the mouse pointer to the desired cell to view the contents of that particular "comment box".)

Calculation Reference
AISC Structural Design
Structural Design
Steel Designers Manual