Department of Civil Engineering

RESIST Research Group

Tools & Spreadsheet Programs

RESIST Group members create advanced spreadsheets using VBA language for their research. We also share these freely with the community to contribute to other studies. You may review the getting started videos to determine their fit into your research. Download links are also provided below. We hope that you will find these tools useful.

Handouts used in our Tutorials
Linear SAP2000 Models:             Truss modeling      Frame Modeling      Special Cases      3D Truss Modeling      3D Frame Modeling 
Nonlinear SAP2000 Models:     Nonlinear Beam Modeling (Default Hinges)      Nonlinear Beam Modeling (Custom Hinges)  
Nonlinear VecTor5 Models:       Continuous Beam      Shear-Critical Frame (pdf)     Shear-Critical Frame (xlsx)  

SUBSCRIBE to our YouTube Channel to reach the latest videos and more.

ANN-ConDeep: Artificial Neural Network for Continuous Deep Beams ANN-ConDeep is developed to predict the shear strength of two-span continuous deep beams using an artificial neural network (ANN). Developed through rigorous training  on an experimental database of 140 specimens, all of which exhibited shear-critical behavior, ANN-ConDeep enables instant shear strength predictions while maintaining accuracy comparable to experimental results Download spreadsheet

Beam-Column Joint Hinge Generator for SAP2000 (Machine Learning Based) Beam-Column Joint Hinge Generator using an Artificial Neural Network (ANN) is developed to predict the joint shear strength and derive the shear stress-strain and moment rotation curves of both exterior and interior beam-column joints with or without transverse reinforcement. Download spreadsheet

Beam-Column Joint Hinge Generator for SAP2000 (Mechanics Based) Joint Hinge Generator is developed to generate shear stress-strain and moment rotation curves of both exterior and interior beam-column joints with or without transverse reinforcement. The generated curves can readily be used in global frame analysis software such as SAP2000. Download spreadsheet

ANN-Customize A VBA-coded spreadsheet that offers an easy and fast way to create and train artificial neural networks for predicting any outcomes using your own variables and training database. Download spreadsheet

Ready-to-Use Artificial Neural Network  for Adhesive Anchors in Cracked Concrete An artificial neural network trained and tested with over 100 experimental results from a worldwide database to rapidly and accurately predict the load capacity of adhesive anchors installed into cracked concrete. Download spreadsheet

Equivalent Cone Method A novel method to permit the three-dimensional concrete breakout phenomenon to be accurately simulated using 2D finite element models only. Download spreadsheet

Fragility Function Generator This VBA-coded spreadsheet is an easy and fast way to create fragility functions for any kind of hazard analysis. It calculates fragilities based on any number of specified performance limits and data points. Download spreadsheet