The engineers require to perform several calculations on daily basis specifically with modern standards like EUROCODES. Microsoft excel with its powerful programming features can make this engineering calculation process simple.
Microsoft excel contains various input parameters which can be entered in very easy to follow and rapid manner. Besides, with excel, a simple sketch can be provided as a graphical representation concerning the basis of the computation with annotations of input parameters. Excel program also facilitates the Engineers to describe the mathematical process with some complicated formulas or iterations.
In this regard, GrSoft Structural Engineering is conducting a useful course for engineers to produce their own customized engineering calculations instantly as well as update formulas in their calculation whenever needed through robust programmable tools in excel.
Create a new Excel worksheet and save as an Excel Macro-Enabled Workbook (.xlsm). From the main menu select the Developer menu item and then click on Visual Basic. Select Insert and Module. In the Project Tree in the left pane of the dialog box below click on Module 1. Enter the following code as shown below. Electrical tools (MS Excel Spreadsheets) This section is dedicated to tools every electrical engineer can use in daily work.These spreadsheets below will make your job much more easier, alowing you to shorten the time used for endless calculations of cables, voltage drop, various selections of circuit breakers, capacitors, cable size and so on.
The course will focus on the following subjects :-
- How to develop cells where input parameters should be entered
- How to develop a sketch involving anotations of input parameters
- How to arrange cells where calculation results will be written
- How to make a push button, where you will activate start of the
OTHER FEATURES:
calculation:
- How to write code for doing calculation
- How to write code to demonstrate the calculation results
- How to execute calculation
Image Courtesy: cesdb.co
This course will also provide guidance to write the software for practical engineering computation for structural analysis. One will also be familiar with how to enter data, describe formulas and make calculation real time along with how to demonstrate results and format cells for results of calculation.
For more information visit engineering-calculations.com
The Excel Engineering Functions perform the most commonly used engineering calculations, many of which relate to Bessel Functions, Complex Numbers or converting between different bases. Engineers may also find the Excel Math and Trig functions useful.
In the tables below, the Excel Engineering functions have been grouped into categories, to help you to find the function you need. Selecting a function name will take you to a full description of the function with examples of use.
Note that some of the functions are new to Excel 2010 or Excel 2013 and so are not available in earlier versions of Excel.
Excel Engineering Functions
| Converting Between Units of Measurement | | CONVERT | Converts a number from one measurement system to another | | Bessel Functions | | BESSELI | Calculates the modified Bessel function In(x) | | BESSELJ | Calculates the Bessel function Jn(x) | | BESSELK | Calculates the modified Bessel function Kn(x) | | BESSELY | Calculates the modified Bessel function Yn(x) | | Converting Between Bases | | BIN2DEC | Converts a binary number to a decimal | | BIN2HEX | Converts a binary number to hexadecimal | | BIN2OCT | Converts a binary number to octal | | DEC2BIN | Converts a decimal number to binary | | DEC2HEX | Converts a decimal number to hexadecimal | | DEC2OCT | Converts a decimal number to octal | | HEX2BIN | Converts a hexadecimal number to binary | | HEX2DEC | Converts a hexadecimal number to a decimal | | HEX2OCT | Converts a hexadecimal number to octal | | OCT2BIN | Converts octal number to binary | | OCT2DEC | Converts octal number to a decimal | | OCT2HEX | Converts octal number to hexadecimal | | The Error Function | | ERF | Returns the error function integrated between two supplied limits | | ERF.PRECISE | Returns the error function integrated between 0 and a supplied limit (New in Excel 2010) | | ERFC | Returns the complementary error function integrated between a supplied lower limit and infinity | | ERFC.PRECISE | Returns the complementary error function integrated between a supplied lower limit and infinity (New in Excel 2010) | | Bitwise Functions | | BITAND | Returns a Bitwise 'And' of two numbers (New in Excel 2013) | | BITOR | Returns a Bitwise 'Or' of two numbers (New in Excel 2013) | | BITXOR | Returns a Bitwise 'Exclusive Or' of two numbers (New in Excel 2013) | | BITLSHIFT | Returns a number shifted left by a specified number of bits (New in Excel 2013) | | BITRSHIFT | Returns a number shifted right by a specified number of bits (New in Excel 2013) |
| | Testing Numeric Values | | DELTA | Tests whether two supplied numbers are equal | | GESTEP | Tests whether a number is greater than a supplied threshold value | | Complex Numbers | | COMPLEX | Converts user-supplied real and imaginary coefficients into a complex number | | IMABS | Returns the absolute value (the modulus) of a complex number | | IMAGINARY | Returns the imaginary coefficient of a complex number | | IMARGUMENT | Returns the argument Θ (an angle expressed in radians) of a complex number | | IMCONJUGATE | Returns the complex conjugate of a complex number | | IMCOS | Returns the cosine of a complex number | | IMCOSH | Returns the hyperbolic cosine of a complex number (New in Excel 2013) | | IMCOT | Returns the cotangent of a complex number (New in Excel 2013) | | IMCSC | Returns the cosecant of a complex number (New in Excel 2013) | | IMCSCH | Returns the hyperbolic cosecant of a complex number (New in Excel 2013) | | IMDIV | Returns the quotient of two supplied complex numbers | | IMEXP | Returns the exponential of a complex number | | IMLN | Returns the natural logarithm of a complex number | | IMLOG10 | Returns the base-10 logarithm of a complex number | | IMLOG2 | Returns the base-2 logarithm of a complex number | | IMPOWER | Calculates a complex number raised to a supplied power | | IMPRODUCT | Returns the product of up to 255 supplied complex numbers | | IMREAL | Returns the real coefficient of a complex number | | IMSEC | Returns the secant of a complex number (New in Excel 2013) | | IMSECH | Returns the hyperbolic secant of a complex number (New in Excel 2013) | | IMSIN | Returns the sine of a complex number | | IMSINH | Returns the hyperbolic sine of a complex number (New in Excel 2013) | | IMSQRT | Returns the square root of a complex number | | IMSUB | Subtracts two complex numbers | | IMSUM | Calculates the sum of two complex numbers | | IMTAN | Returns the tangent of a complex number (New in Excel 2013) |
|
Analysis Toolpak
Excel For Engineers And Scientists
If the Excel Engineering functions are not available to you, you will need to load the Analysis Toolpak.
Engineering Xls
Return to the List of All Built-In Excel Functions
Return to the ExcelFunctions.net Home Page