Yearly Archives: 2018

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