Engineering Toolkit
$5
https://schema.org/InStock
usd
Alan Hankins
Whether you're estimating wind pressures, checking slopes, or just tired of writing the same formulas over and over β this toolkit is for you.
The Engineering Toolkit for Excel is a collection of plug-and-play functions designed for civil, structural, and drafting professionals. It runs entirely inside Excel using VBA β no coding required.
βοΈ What You Get:
- A VBA module (
EngineeringToolkit.bas) with 10+ useful functions - A working example workbook (
.xlsm) showing real use cases - A quick-start PDF with install instructions and screenshots
- Annotated image folder showing how each function works
π‘ What It Does:
- LinearInterp β Interpolates values between two known points
- LinearInterpFromRange β Interpolates using Excel ranges (e.g., strength vs curing time)
- BilinearFromGrid β Estimates values from a 2D grid (e.g., pressure from terrain/height)
- AreaOfPolygonXY β Calculates area from a list of surveyor X/Y coordinates
- RoundToNearestStep β Rounds numbers to standard steps (e.g., bolt pitch spacing)
-
CombineUnits β Formats outputs with tolerances (e.g.,
25 mm Β± 2 mm) - UnitConvert β Converts between pressure, force, length units (e.g., kPa to psi)
- WeightToNewtons β Converts mass to force (e.g., kg to kN)
- ElasticDeflection β Calculates beam deflection under point load
- SlopePercent β Calculates gradient or slope percentage for ramps, drains, etc.
π― Who Itβs For:
- Engineers who use Excel daily
- Draftspersons doing hand calcs or QA checks
- Students looking to speed up assignments or design work
Install it in 30 seconds. Use it forever.
A time-saving Excel toolkit for engineers, with ready-to-use formulas and functions.
Format
Excel (.xlsm), VBA Module (.bas)
Functions Included
10 engineering tools
Excel Version Required
Excel 2016 or later (PC)
VBA Required?
Yes β Macros must be enabled
Installation Time
Less than 30 seconds
Skill Level
BeginnerβIntermediate Excel user
Use Cases
Interpolation, deflection, tolerances
File Size
1.5 MB (zipped)
License
Business Tool / Lifetime Use
Size
285 KB
Add to wishlist