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 works by adding functionality to any existing Excel workbook with Dissolved Gas Analysis data. To get started with xDGA, begin by downloading the *.XLL file which contains the add-in. There are two versions of the add-in. Download this version if you have a 32-bit Windows computer Download this versionRead More →
If you’ve enjoyed xDGA so far, you should give xDGA Pro a try. Available in preview for a limited time. https://xdga.pro/blog/launch-of-xdga 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 theRead More →
Create an Excel lookup formula that searches a table using criteria from various columns. It mimics the functionality of the native VLOOKUP() formula using a combination of the INDEX() and MATCH() function. Ingredients Microsoft Excel The Need There is no doubt that one of the most useful and often used Excel functionsRead 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 Add a Custom Tab to the Office Ribbon with controls to trigger your code functions. Ingredients Microsoft Office Custom UI Editor for Microsoft Office The Need When building custom functionality or macros in a Excel or Word, you might want to provide the user with a User InterfaceRead More →
Short Description Create an Excel Add-in that allows you to add Application Settings functionality on any Workbook. Store and retrieve setting names and values on a centralised location and accessible anywhere from your VBA modules and classes. Ingredients Microsoft Excel The Need Sometimes when you are creating an Excel tool or application,Read 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 →