Math problem converting from Imperial units to si units

[swemek]

Hey all!

I'm converting calculations from Imperial units to si units, but can't get it to match. I don't know if I did some conversion error or what is wrong. Or I'm blind.

The red should match up the green

I need your expertise.

Regards M

 

[Tetra201]

Try in cell B14

=(B11+B5/12)/B10

 

[shift-del]

Hi

CONVERT() does the converting.

 

[swemek]

Try in cell B14

=(B11+B5/12)/B10

Thanks! But it is the red that must match the green. The green is the right one.

 

[Tetra201]

No, the green is the wrong one: you are adding together feet (B11) and inches (B5).

 

[rlv01]

Hey all!

I'm converting calculations from Imperial units to si units, but can't get it to match. I don't know if I did some conversion error or what is wrong. Or I'm blind.

The red should match up the green

I need your expertise.

Regards M

Your cell E11 value is wrong. Should be 0.21615288 (i.e. 8.509955916 inches <> 2.593834563 meters)

0.216153​

 

[swemek]

Thanks! You are right! Can you see what I did wrong?
My brain is over cooked
0.21615288 =(E8^2)*E2*(1+2*E$10/E1/E8)*2

 

[rlv01]

I could if you could post it using XL2BB, which would allow me to paste both values and formulas into a worksheet to analyze. The graphic image is too hard to work with.

BTW, if you post a graphic image of your data, the number of people willing to manually type in your data to experiment to help you will be limited. Consider using this free tool instead to post some sample data.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

 

[Tetra201]

@ rlv01: Before diving any deeper, take a look at the formula in cell B11. It uses only ft, s, fps, and ft/s2, and it has no conversion into inches. So, the number in cell B11 is in feet, not in inches. Then, in cell B13, feet (B11) and inches (B5) are summed without any conversion, which is obviously wrong.

 

[swemek]

Convert.xlsx
	A	B	C	D	E	F
1	fps	2851.049869		m/s	869
2	ft/s2	32.1740486		m/s2	9.806650013
3
4
5	inch	1.5		m	0.0381
6	inch	1.57480315		m	0.04
7	feet	0.184358596	=(0,425*B5+B6)/12	m	0.0561925	=(0,425*E5+E6)
8	s	0.214103532	=SQRT(8/B2)*SQRT(B7)	s	0.214103532	=SQRT(8/E2)*SQRT(E7)
9
10	feet	575.3168920		m	175.3565887
11	inch	8.509955916	=(B8^2)*B2*(1+2*B$10/B1/B8)*2	m	2.593834563	=(E8^2)*E2*(1+2*E$10/E1/E8)*2
12
13
14		0.001449919	=(B11+B5)/B10/12		0.015009043	=(E11+E5)/E10
15
Blad1

Cell Formulas
Range	Formula
B7	B7	=(0.425*B5+B6)/12
B8,E8	B8	=SQRT(8/B2)*SQRT(B7)
E7	E7	=(0.425*E5+E6)
B11,E11	B11	=(B8^2)*B2*(1+2*B$10/B1/B8)*2
B14	B14	=(B11+B5)/B10/12
E14	E14	=(E11+E5)/E10