Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Latex Maths Text in Excel
- Commenting a block of code in VBA
- Cubic Splines
- Removing Add-ins
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Solving cubic and quartic equations with Excel
- Retrieving unique values from a range or array ...
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
Recent Comments
Tag Archives: Evaluate text
Units and solvers with Pint and Sympy
Following the previous post I have adapted the units code to use the Pint package, and added a function using the Sympy equation solver, with Pint units. I have applied the functions to finding the depth of neutral axis of a … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, UDFs, VBA, xlwings
Tagged Evaluate text, evaluate units, Excel, Pint, Python, Solve text, Sympy, UDF, unit aware, Units, VBA, xlwings
1 Comment
Working with implied units – update
Following comments at Eng-Tips I have added two examples with different procedures for evaluating ACI equations for the flexural tensile strength of concrete here.
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged ACI 318, Customary US Units, Eval, EvalU, Evaluate text, Excel, Implied units, shear capacity, SI Units, UDF, Units aware, Units4Excel, VBA
Leave a comment
Working with implied units
The Units4Excel spreadsheet provides a number of functions to convert between different units and evaluate functions entered as text on the spreadsheet, taking account of the units of both the inputs and the results. The latest version can be downloaded from: … Continue reading
Posted in Concrete, Excel, Maths, Newton, UDFs, VBA
Tagged ACI 318, Customary US Units, Eval, EvalU, Evaluate text, Excel, Implied units, shear capacity, SI Units, UDF, Units aware, Units4Excel, VBA
2 Comments
UDF to replace cell references with values
I recently posted an update to the Eval2 spreadsheet with a subroutine to display a cell formula as a text string, with the cell references replaced by the associated values. I have now added three user defined functions (UDFs) to do … Continue reading
Posted in Excel, UDFs, VBA
Tagged display formula reference values, Evaluate text, Excel, UDF, VBA
Leave a comment