Skip to content

Follow Us

  • LinkedIn

Follow Us

  • X

Follow Us

  • GitHub
Engineers Tools
Engineers Tools
Primary Navigation Menu
Menu
  • Engineering Disciplines
    • Automation Engineering
    • Chemical Engineering
    • Civil Engineering
    • Computer Engineering
      • Software Engineering
    • Electrical Engineering
    • Industrial Engineering
    • Mathematics
    • Mechanical Engineering
    • Mining Engineering
    • Reports and Documentation
    • Systems 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 Engineering Disciplines, Software Engineering
Tagged document automation, document generation, excel, excel automation, vba, word, word document generator, work instructions

xDGA

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 →

2017-09-23
In Chemical Engineering, Electrical Engineering, Software Engineering
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

Search Posts

Subscribe to Engineers Tools

Enter your email to get notified when we post new tools, articles, or videos.

Recent Comments

  • Engineers Tools on How to use xDGA
  • Arend on How to use xDGA
  • Engineers Tools on Symmetrical Components
  • Hussain Mayouf on Symmetrical Components
  • Engineers Tools on How to use xDGA
  • Kevin Garcia on How to use xDGA
  • Engineers Tools on xDGA
  • sacotte michel on xDGA

Topics

.NET application development architecture Asset Management Australia C# CAD Calculations Chemical Circuit Design Circuit Modelling clean architecture Computer Aided Design define Digital Asset Management Drawing Education Electrical Engineering Energy Transformation engineers tools excel excel add-ins FEA features FEM Finite Element Analysis Finite Element Modelling frameworks github hierarchies iec 60599 Mathematics Modelling Molecules Photogrammetry Physics power transformers power transformers oil analysis Processes Programming quasar Simulation Software Development vba VLookup

About Us

  • Our Story
  • Privacy Policy

Subscribe to Engineers Tools

Enter your email address to get notified when we post new tools, articles, or videos.

Join 26 other subscribers

Copyright © 2025 Engineers Tools