I was tasked with conducting the code research for this project which turned out to be quite extensive. Not only did the project have to comply with the usual codes such as IBC, ADAAG, and NFPA 101 but also FHA and ANSI regulations. As I researched the Codes, I saw an opportunity to streamline some of this process and at the same time, show the information on the construction set clearly. In Microsoft Excel, I was able to develop spreadsheets for calculating Maximum Build-able Area (using the Area Modifier formulas found in the International Building Code), Parking Counts using the formulas from the local Code of Ordinances, and to show the building area totals. I was then able to insert and link the spreadsheets to the AutoCAD sheets. This gave us a template that we could utilize on future projects and became the office standard for all future Multifamily work.