MATCH

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

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