Civil / Structural
- Automated pile (re)numbering (prefix, incremental padded integer, suffix).
- Automated beam (re)numbering (prefix, incremental padded integer, suffix) in accordance with pipeline alignment and additional rules.
- Automated pile schedule creation (perform a week’s worth of work in minutes).
- Automated analysis of structural model data: comparison to corresponding piping model shoe locations. Automatic (3D model) clouding of any support member that deviated more than 5mm from its associated piping shoe elevation.
- Parametric program for rebar design, c/w MTO.
- Design, creation, documentation and training of GIS system for streets maintenance.
Electrical / Instrumentation
- PLC programs to operate Water Treatment Plants (in their entirety). One of the larger ones sported 1100 I/O, 2000 rungs of ladder logic and 13000 internal registers. Had to hack the GE (9070) Fanuc software’s data structures and supplement with custom programming just to manage all the data as GE’s software was inept.
- PLC programs to control irrigation canal structures (overshot gates).
- Raceway modeling program. Parametric design, provided ability to create approximately 16,000 unique modeled raceway fittings, c/w embedded intel and a BOM module. Client used application suite for about 10 years. At the time (mid 1990s) there were no comparable 3D modeling programs for raceways.
- Automated tagging of instrumentation and equipment by extracting data from AutoPLANT® piping and equipment models. Instrumentation layout drawings could be subsequently tagged and completed in minutes.
- Automatic drawing creation and pre-population of Electrical Heat Tracing drawings by harvesting existing Piping ISO drawings. Could create an entire project’s worth of pre-populated EHT drawings in about 15 minutes.
- On demand updates of EHT drawing tabular data by importing data from excel (without need for problematic hard links).
- Creation of cable schedule drawings by reading cable schedule data from database. Created 600 drawings in less than a day (c/w index).
Piping / Pipelines / Process
- Piping ISO batch renaming c/w in document reference renaming (in attributed blocks, mtext, text etc). Estimate to perform task manually: 160 hours. Wrote program, executed and reviewed final output in 2 hours.
- Piping spec summarizing program (for auditing purposes). Reduced typical 50-60 page report to just 6 pages.
- Utility to find and highlight any piping or equipment with invalid or errant spec data.
- Conversion of AutoPLANT® BOM reports to very specific, non trivial client data formats. Said to compress weeks of work down to about 5 minutes.
- Automated Top Of Steel (T.O.S.) design methodology. Colleagues informed me it typically reduced a month’s worth of effort to just 3 days. As a result far more design iterations could be explored and better designs resulted, notwithstanding huge (reported 20%) project cost reductions.
- Once T.O.S. design complete automated generation of 3D info for pipeline (centreline) routing and the guided placement of structural steel members. This changed weeks of work into hours of work.
- Utility to perform automated “roping” (vertical transition technique that exploits inherent pipe sag) design calcs.
- Automated generation of utility crossing information.
- Extract all tags from P&ID drawings and cross referenced against LDT data from excel. Identified tags that existed on drawings but didn’t reside in the LDT spreadsheet — and vice versa. Week’s of (blinding, headache inducing) review work performed in about half a day.
- Harvested BOM data from hundreds of Piping ISOs. Client made the very big mistake of editing the drawings manually instead of updating the AutoPLANT models / database and regenerating the ISOs and the BOM reports. Do not manually edit ISOs! Client tried for weeks to manually extract the data from the drawings to no avail. I was contacted in a panic. I wrote a program, harvested the data and compiled a database in 3 days.
- Project Selector. Used to map network drives, network rights and configure CAD applications to suit client and project requirements. Upgraded numerous times to reflect operating system, network and CAD software upgrades. Used by client for about 10 years.
- Program to harvest, analyze, reconcile, harmonize and update equipment tags on thousands of drawings distributed over multiple cities.
- Auditing of thousands of drawings to identify deal breaking, non compliant items.
- Turnover of thousands of drawings after automatic updates to fix non compliant items (identified in previous item) and subsequent automated flattening.
- Automated extraction and formatting of drawing metadata from thousands of drawings (for subsequent use by document control).
- Binding of approximately 900 drawings (it’s not what I would recommend but it’s what the client wanted).
Thank you for reading this page.