Alert Property Inspections
Alert Property Inspections contacted me to create a Visual Basic for Applications (VBA) script (or macro) that they could use in Excel to generate the Head Impact Coefficient (HIC) required as part of the playground safety assessments they perform. The coding was done in two phases.
In phase one the VBA code was created (based on pseudo code noted in the ASTM standard) to calculate the HIC from filtered data outputted from the Triax 2000 testing device. The code also displays the start and end sample used to generate the HIC.
In phase two the VBA code was expanded to also include a scatter gram plot that shows:
- g-force versus sample time scatter gram plot
- the start and end samples used in the calculation of HIC
- the highest g-force sustained for a 3ms period
This project was coded in Excel using VBA and was based on pseudo code provided by the ASTM standard.
Website:
Screenshot:
