Skip to content
Engineers Tools
Primary Navigation Menu
Menu
  • Articles
  • Software Tools
    • Chemical Engineering
    • Electrical Engineering
    • Mathematics and Calculations
    • Mechanical Engineering
    • Modelling and Design
    • Productivity
  • Books
    • Electrical Engineering
  • Contact Us

excel

WinWriter

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 →

2018-01-28
In Productivity
Tagged document automation, document generation, excel, excel automation, vba, word, work instructions

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 the results of Dissolved Gas Analysis in Liquid Filled Electrical Apparatuses such as Power Transformers, On-Load Tap Changers, Circuit Breakers, etc. TheRead More →

2017-09-23
In Transformers
Tagged analysis algorithms, dga excel formulas, dissolved gas analysis, duval pentagons, duval triangles, excel, excel add-ins, iec 60599, ieee c57.104, power transformers, power transformers oil analysis, rodgers rations

Excel Custom Formula – GetSheetName()

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 →

2016-02-20
In Software Engineering
Tagged Custom Formula, excel, Formula, UDF, User Defined Function, vba

Excel Lookups in any Direction

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 →

2016-01-16
In Software Engineering
Tagged Data Table, excel, HLookup, Search, VLookup

Topics

analysis algorithms Application Settings Artificial Intelligence CAD Calculations Chemical Computer Aided Design Data Table dga excel formulas Digital Asset Management dissolved gas analysis document automation document generation Drawing duval pentagons duval triangles Education Electrical Engineering excel excel add-ins excel automation FEA FEM Finite Element Analysis Finite Element Modelling HLookup how to iec 60599 ieee c57.104 machinelearning Mathematics Modelling Molecules Office Physics power transformers power transformers oil analysis Ribbon rodgers rations Search vba VLookup word work instructions xDGA

About Us

  • Our Story
  • Privacy Policy

Copyright © 2022 Engineers Tools