Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Downloads by category
- Latex Maths Text in Excel
- Deflections and Moments in Rectangular Plates
- The history of the theory of beam bending - Part 1
- Retrieving unique values from a range or array ...
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads
Recent Comments
Tag Archives: Unit conversion
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
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
Daily Download 24: Units for Excel
The Units4Excel spreadsheet provides: User Defined Functions (UDFs) to convert between any listed units, including compound SI units. A UDF to evaluate any function entered as text, including evaluation of input and output units. Recognition of all standard SI prefixes. An … Continue reading
Units for Excel 5:
Previous post on Units for Excel Download spreadsheet: Units4Excel.zip I have posted a new update of the Units4Excel spreadsheet for download (link above). The main changes are: The ConvertA and ConvertA2 functions have been combined. The ToSI and FromSI functions have been deleted, … Continue reading
Posted in Excel, Newton, UDFs, VBA
Tagged Excel, UDF, Unit conversion, Units, Units aware, VBA
3 Comments