In Productivity
Tagged , , , , , ,

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 the Word template. WinWriter allows you to maintian a set of work instructions in Excel which can be easily copied, pasted, modified and updated wihtout worrying about the formatting aspects of the final document. The best way to understand the power of WinWriter is to try it out. License The MIT License (MIT) Copyright (c) 2018 Carlos Gamez PermissionRead More →

In Transformers
Tagged , , , , , , , , , , ,

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. The custom formulas are packaged as an Excel XLL Add-in which doesn’t require any additional software installed on your computer. Simply double-click on the xDGA.ADDIN.xll file and start using the formulas. If you’ve ever tried to apply any of the available analysis guidelines, you’ll know that some of them are dozens of pages worth of information.Read More →

In Software Engineering
Tagged , , , , ,

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 a few reporting templates where the main title of each page corresponds to the Worksheet name. In that scenario it is handy to have the name of the Worksheet automatically change in the title of the report. This technique is particularly handy to create preformatted Worksheets which you can then copy/paste and customise, starting with theirRead More →

In Software Engineering
Tagged , , , ,

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 for value>,0)) Searching a row and returning a value in another row =INDEX(<Row to extract value from>,1,MATCH(<Value of criteria used for looking>,<Row to be searched for value>,0)) Ingredients Microsoft Excel The Need In many scenarios, data held in the form of a table needs to be searched for a certain criteria and when the criteria is met some pieceRead More →