Remember back to the days when you used allowable stress design for designing anchorage to concrete? Once you had your design loads, selecting an anchor was quick and easy. The 1997 UBC covered the anchorage to concrete in less than two pages, so the calculation was painless. Post-installed anchors were even easier, since allowable loads were tabulated and you just needed to apply a couple of edge distance and spacing reductions.
Since the introduction of strength design provisions and the adoption of ACI 318 Appendix D, first in the 2000 IBC, designing code-compliant anchorage to concrete has become much more complex. At least once (and probably not more) armed with a pencil, calculator, and an eraser, most of us have set out to design a ‘simple’ anchorage to concrete connection using the Appendix D provisions. Several pages of calculations later (and hopefully with a solution to the problem), most of us, I imagine, came to realize that designing anchorages to concrete by hand required much more time and effort than we anticipated or could allocate time for. As a result, many of us probably created an Excel template to speed up the design process using built-in functions and some Visual Basic programming.
The question is: are you still using the template?
For me, the answer is an emphatic “NO”, mainly because the spreadsheet I created has limited capability given the complexity in adapting the design methodology to complex anchor layouts, changes to the design provisions with each new code edition, and the need to add/modify data each time a new post-installed anchor product is introduced.