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

#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

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

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

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

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

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

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

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

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