Karl Hoitsma, P.E.
I am interested in doing consulting work for other engineers.
- Commercial, or
For instance, happy to assist with review, checking, calculations, or programming.
Typically available on short notice, tight deadlines, willing to work off-shift – nights, weekends.
Email: khoitsma at mathpax.com
Extensive experience in programming suited to engineering work — examples follow:
|ASCE Exact Wind Integration (closed form equations)||Developed single function to calculate all aspects of ASCE wind design:
|Multi-Page Apps using Dash/PythonAnywhere Apr2020||Developed working online apps for structural design:
|WT Braces Mar 2020||Developed design basis for eccentrically loaded WT brace members, allows comparison with concentric braces|
|Single angle braces vs WT braces Feb 2020||I compare the simplicity and efficiency of single angles to WT braces|
|Calculate Beta w for Single Angles Dec 2019||The beta value for single angles is an elusive parameter. I developed a closed form solution for the beta value.|
|AISC Bolt Shear — C Coefficient Jul 2019||Here is my iPhone app for determining bolt group coefficients – with plots.
|ASCE 7-16 Kzt Calculation — with Chart Jul 2019||Here is my iPhone app for determining the ASCE Kzt parameter.
|AISC Bolt Shear Capacity — Improved UI Jun 2019||Here is my iPhone app for determining the allowable bolt shear in accordance with AISC.
Beautiful, very quick to use.
|Brom’s Method Sep 2017||Rigid shaft foundation design|
|ASCE 7-16 Ice Loading Apr 2018||Developed function, get_iceweight()
|Wind and Fire-proofing Dec 2017||Explicit wind calculation for steel members including fireproofed beams and columns.
|Multi-Dimension Data Table using PyXLL (with video) Dec 2020
||I coded a PyXLL macro that builds a multi-dimension data table.
The native Data Table provided by Excel is useful but limited to two variables.
My version is set up for 5 dependent variables and an unlimited (theoretically) number of dependent variables.
|Excel Dropdown with NO worksheet data list (with video) Nov 2020
||I built an Excel dropdown function — that requires no worksheet reference!
The dropdown built into Excel requires a range of data to populate the dropdown list. This might be an appropriate situation if the spreadsheet is a one-off. In my work, the dropdown list would more appropriately be generated in my PyXLL program.
Having the dropdown and its data provided by a PyXLL function allows:
|Feet Inches Sixteenths (FIS) Calculator
||I built an Excel FIS Calculator
Reference on this website to any specific commercial products, process, service, manufacturer, company, or trademark does not constitute its endorsement or recommendation by Karl Hoitsma.