Department of Civil Engineering

RESIST RESEARCH GROUP

TOOLS & Spreadsheet Programs

RESIST Group members create advanced spreadsheets using VBA language for use in 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-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