Engineering

A selection of articles related to engineering topics of interest. Please add your input in the comments section for the benefit of all.

Worldmap with gapminder data — The following is a quick guide to getting up and running quickly in Python on a Work Computer. I personally find Anaconda overkill for simply running some python scripts. Plus, Anaconda was removed from the corporate Software Center App. This process should take about 5 minutes to get up and […]

Git up and Running with Python on a Work Computer

2022-08-13 in Engineering tagged matplotlib / numpy / plotly / python / Tutorial / VSCode / windows

Process flow diagram of the water treatment plant — Tutorial using machine learning clustering algorithms on a wastewater treatment plant from daily sensors. Python code provided on GitHub.

ML Clustering of a Waste Water Treatment Plant

2020-11-22 in Engineering tagged k-means / machinelearning / python / scikit-learn / scipy

#Project #Management outline from initialization to closeout put together using PMBOK's 5th edition Guide as a reference. All text files can be downloaded from my repo and ready for use for your own PM journey.

Project Management Outline Reference

2020-09-25 in Engineering tagged management / projects

This article covers my setup of a clean slated #macOS decked out with an aesthetically pleasing #CLI and #Python setup ready for development. #Homebrew > #Git > iTerm2 with Oh My Zsh with fzf powerful fuzzy searching and integration with #vim

macOS Initial setup of CLI and Python Dev

2020-09-08 in Engineering tagged CLI / macOS / python

Windows WSL1 Pip Flow — Article covers my setup of Python on both Windows 10 using Chocolately and WSL 1 (Debian distro) using pip tools. Clean install through to git version control discussed.

Python, pip, WSL 1 Debian Setup on Windows 10

2020-09-01 in Engineering tagged python / windows / wsl

Flow diagram of the software setup for WS2 Python Win10 Setup — I cover my setup of Python on both Windows 10 using Chocolately and WSL 2 (Ubuntu distro) using Miniconda. Discuss PowerToys and Jupyter.

Python, Conda, WSL 2 Ubuntu Setup on Windows 10

2020-08-27 in Engineering tagged linux / python / windows / wsl

Is weekly timesheet entry at the bottom of your task list? I have tried many systems to enlighten this chore, from pen and paper to now online time tracking and reporting using #Python #API requests. This is an early version of a personal #KPI metrics based system, that I can extend to suit project specifics.

Online Time Tracking and Reporting with Python API

2020-04-09 in Engineering tagged API / Excel / pandas / python

Using Python, we will extract the APRA MySuper Heatmap data and create easy to read heatmaps of the top 15 funds based on returns and finding low fees.

Simplified APRA MySuper Heatmaps with Python

2020-04-05 in Engineering tagged pandas / python / seaborn

intersecting painted lines on the road — Linear interpolation in Microsft Excel: =IFERROR( IF( [@[x_axis]] = MAX(T_Inputs[x_axis]), INDEX(T_Inputs, MATCH([@[x_axis]], T_Inputs[x_axis], 1 ), MATCH([@[data_columns]], VALUE(T_Inputs[#Headers]), 0) ), ( INDEX(T_Inputs, MATCH([@[x_axis]], T_Inputs[x_axis],1), MATCH([@[data_columns]], VALUE(T_Inputs[#Headers]), 0 ) ) * ( IF([@[x_axis]] = MAX(T_Inputs[x_axis]), MAX(T_Inputs[x_axis]), INDEX(T_Inputs[x_axis], MATCH([@[x_axis]], T_Inputs[x_axis], 1 ) + 1) ) – [@[x_axis]] ) + IF([@[x_axis]] = MAX(T_Inputs[x_axis]), MAX(T_Inputs[x_axis]), […]

Linear Interpolation Using Python – Much simpler than Excel

2020-03-04 in Engineering tagged matplotlib / numpy / python / scipy

This post is part 1 of a series of posts I intend to pen related to a personal engineering tracking workbook that I put together for each of my projects. I plan to keep the length short and manageable, as well as breaking it out for others to go to […]

Project Tracking Workbook | Part 1 Actions

2019-07-02 in Engineering tagged Excel / INDEX / MATCH / MID / RIGHT / SUBSTITUTE / TABLE / TRIM

The 2018 edition of the Power Piping code was issued on 20 July 2018 and will come in effective on 20 January 2019. The next scheduled publication is in 2020. The following is an extension to the summary of changes from the 2016 edition. I included the changes exactly as […]

ASME B31.1 Power Piping 2018 Changes

2018-09-16 in Engineering tagged ASME / B31 / Power Piping

Excel Table showing all the extracted data from the web — Have you ever wanted to extract information from a web page to use in a calculation, or as a reference for something else you may be working on? I have used similar functions in the past (pre Power Query days) to grab stock price information or Forex rates for personal finance […]

Engineering Data Extracted from the Web Using Power Query

2018-08-05 in Engineering tagged Excel / Function / Parameter / Power Query / Spreadsheet / Tutorial

Written Equation and Graph — Linear interpolation according to Wikipedia is a method of curve fitting using linear polynomials to construct new data points within a discrete set of known points. Or more appropriately defined as getting the value in a numerical table which almost always lies somewhere between known values when you are looking for […]

Linear Interpolation Using Microsoft Excel Tables

2018-01-31 in Engineering tagged ASME / B16.34 / Functions / IFERROR / INDEX / MATCH / MAX / Spreadsheet / VALUE / Valves

Five pressure vessel books on a bookshelf — What are your go-to books for pressure vessels? Aside from the codes and standards relevant to your jurisdiction, which texts have you put skin in the game? Please feel free to list in the comments, as it would be valuable to all to know what others have in their collection. […]

Pressure Vessel Books for Design Fabrication Operation

2017-10-03 in Engineering tagged book / mechanical / vessel

Follow these 3 simple steps to getting your lowest home energy bill in Australia. Method of getting energy offers and spreadsheet provided. Start saving now

Energy Home Bill High? How to get the Lowest in ...

2017-08-23 in Engineering tagged Spreadsheet / Tutorial