WinWriter is an Excel template that can be used to automatically generate Work Instructions as Word documents. This provides a great separation of concerns by keeping the content of the documents in an easy to manage table-like format while the look and feel of the Work Instruction is controlled via theRead More →
xDGA is a free and open-source tool. xDGA implements a set of Excel formulas that give you the ability to run industry best-practice algorithms to evaluate and assess the results of Dissolved Gas Analysis in Liquid Filled Electrical Apparatuses such as Power Transformers, On-Load Tap Changers, Circuit Breakers, etc. TheRead More →
Short Description Create a simple Excel function that returns the name of the Worksheet where that cell is. Ingredients Microsoft Excel The Need When working with Excel Workbooks that contain multiple Worksheets, you might need to get the name of the each Worksheet in formulas. For example, I have aRead More →
Short Description Perform searches in Excel rows or columns and extract data in any direction from the found reference. The final form of this recipe is: Searching a column and returning a value in another column =INDEX(<Column to extract value from>,MATCH(<Value of criteria used for looking>,<Column to be searched forRead More →