Recent Comments
dougaj4 on The answer to Life the Univers… 
Paul Halsema on The answer to Life the Univers… More powers of 3 | N… on The answer to Life the Univers… 
Onyia Leonard on Daily Download 4: Continuous B… The age of snakeoil… on They all laughed at Christophe… dougaj4 on Buckling of columns with varyi… 
Manoj Deo on Buckling of columns with varyi… dougaj4 on Buckling of columns with varyi… Manoj Deo on Buckling of columns with varyi… Indexing pdf files,… on Indexing pdf content dougaj4 on The answer to Life the Univers… 
Matija Bandić on The answer to Life the Univers… 
Afazio on Plotting Mandelbrot dougaj4 on Plotting Mandelbrot Afazio on Plotting Mandelbrot
Tag Archives: Eval function
Converting a formula to values
Excel has a built-in function (FormulaText) to display a formula as cell references, rather than the result value. It would be useful to be able to display the value of each cell reference as well, but there is no built-in … Continue reading
Evaluating text – update
One disadvantage of the spreadsheet style interface is that even simple formulae are difficult to check. For instance, the deflection of a cantilever loaded at the end is given by: F*L^3/(3*E*I) which is much easier to read than the Excel … Continue reading
Posted in AlgLib, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Eval function, evaluation of text strings, Excel, UDF, Unit conversion, Units, Units aware, VBA
4 Comments
Daily Download 17: Numerical Integration
Some simple numerical integration functions (using the trapezoidal rule and Simpson’s Rule) were included in the Eval2 spreadsheet, presented on Daily Download Day 15, but for purposes were better accuracy and/or higher speed are required more sophisticated methods will do a … Continue reading
Posted in AlgLib, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged AlgLib, Eval function, Excel, Gauss-Kronrod, numerical integration, Tanh-Sinh method, UDF, VBA
Leave a comment
