Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Deflections and Moments in Rectangular Plates
- Latex Maths Text in Excel
- Downloads by category
- Retrieving unique values from a range or array ...
- Fitting high order polynomials
- Using conditional formatting with array formulas
- P-Y Curve function
Recent Comments
Tag Archives: Units
Using ConbeamU
This post was prompted by a thread at Eng-Tips: https://www.eng-tips.com/viewthread.cfm?qid=501339 The beam analysis functions in the ConbeamU spreadsheet allow for the use of any SI units, or any non-SI units found in the long list included with the spreadsheet. I … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, Excel Solver, Maximum deflection, Maximum moment, UDFs, Units, VBA, Working with units
5 Comments
Extracting text from an Internet table
For use in my Units spreadsheet (Units4Excel) I want to extract the unit conversion values from the comprehensive Wikipedia unit conversion table. On Wikipedia the table looks like this: and when copied and pasted as Unicode text into Excel, like … Continue reading
Posted in Excel, Newton, UDFs, VBA
Tagged Excel, Extract from text, UDFs, Unit conversion, Units, Units4Excel, VBA, Wikipedia
3 Comments
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
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
5 Comments
Feet and inches, and other units
Following a query at Eng-tips I have had a look at options in Excel for converting metres to feet and inches, with the inches displayed as a fraction rather than a decimal. Converting from metres to feet or inches is … Continue reading