### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Latex Maths Text in Excel
- Using LINEST for non-linear curve fitting
- Commenting a block of code in VBA
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Deflections and Moments in Rectangular Plates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Pint, MPmath and implied units, working with Excel
- Using Goal Seek on Multiple Cells
- Beam actions and deflections by Macaulay's Method

### Recent Comments

Latex Maths Text in… on Pint, MPmath and implied units… dougaj4 on The VBA Decimal data type Ludek on The VBA Decimal data type dougaj4 on The VBA Decimal data type Ludek on The VBA Decimal data type dougaj4 on About Newton Excel Bach Reinaldo Chohfi Jr. on About Newton Excel Bach Solving cubic equati… on Solving Quadratic, Cubic, Quar… David N on A Match Function Bug … dougaj4 on A Match Function Bug … SectionProperties up… on SectionProperties update updat… David N on A Match Function Bug … dougaj4 on Fitting 3D circles to scattere… Aaron on Fitting 3D circles to scattere… dougaj4 on 3D plots with the latest …

# 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