Conversion
Conversion
Conversion
6 Distance 23 Stress
7 Energy 24 Temperature
9 Force 26 Torque
15 Illumination 32 Weight
16 Length 33 Work
17 Moment of a Force
No Documentation
A1 Features Description of Template Capabilities
A2 User Notes Notes for Using UnitsCalc
A3 Consistent Set of Units Using Units in Structural Dynamics
A4 Terms Terms & Conditions of Use
A5 Revision History Revision History of UnitsCalc
UnitsCalc20020708 Ó 2002 Dr Shaiq Khan, Techno Consultants Ltd
File: 495005421.xls Tab: Force per Unit Volume Date Printed: 10/15/2020
DISTANCE; LENGTH [ L ] F
Known Value = 1 #VALUE!###
#VALUE! #VALUE! Angstrom ###
#VALUE! #VALUE! Micron ###
#VALUE! #VALUE! Millimetre ###
#VALUE! #VALUE! Centimetre ###
#VALUE! #VALUE! Decimetre ###
#VALUE! #VALUE! metre ###
#VALUE! #VALUE! Hectometre ###
#VALUE! #VALUE! Kilometre ###
#VALUE! #VALUE! Thou (Mil) ###
#VALUE! #VALUE! Inch ###
#VALUE! #VALUE! Foot ###
#VALUE! #VALUE! Yard ###
#VALUE! #VALUE! Furlong ###
#VALUE! #VALUE! Mile ###
#VALUE! #VALUE! Link ###
#VALUE! #VALUE! Rod (Pole, Perch) ###
#VALUE! #VALUE! Chain ###
#VALUE! #VALUE! Fathom ###
#VALUE! #VALUE! Int. Nautical Mile ###
#VALUE! #VALUE! UK Nautical Mile ###
#VALUE! #VALUE! Light-year ###
#VALUE! #VALUE! Parsec ###
UnitsCalc20020708 Ó 2002 Dr Shaiq Khan, Techno Consultants Ltd
File: 495005421.xls Tab: Force per Unit Length Date Printed: 10/15/2020
ILLUMINATION F
Known Value = 1 #VALUE!###
#VALUE! #VALUE! Foot-candles ###
#VALUE! #VALUE! Lux ###
#VALUE! #VALUE! Metre-candles ###
UnitsCalc20020708 Ó 2002 Dr Shaiq Khan, Techno Consultants Ltd
Features of UnitsCalc
Interactive Conversion of Measurement Values in Various Units
by
Dr Shaiq U.R. Khan
BEng (Civil), MEng, PhD, CEng, FIStructE
05 December 2001
Techno Consultants Ltd
117 Portland Street, Manchester M1 6ED, England
UnitsCalc is an Excel 97/2000 Template for the conversion of measurements among units of physics and mechanics
used by engineers and architects in the building trade.
The systems of units covered are: British Imperial System, French Metric System, U.S. Customary System, the
International System of Units and some other units used in practice e.g. navigation, astronomy, etc.
Features
¨ The file size is under 500 KB. At 3 KB/second, your download time would be around 4 minutes.
¨ A mouse click converts a known measurement from any one unit to rest of the units in a convesion table.
¨ Conversion values can be copied to the clipboard for use elsewhere..
¨ Help button for instant instructions of use.
¨ Control for decimal places in normal size numbers.
¨ Full Documentation is included within the template i.e. Features, Consistent Set of Units, User Notes, Terms and
Conditions of Use and Revision History of the Template.
Unit Quantities
¨ Acceleration:
Free fall (g), Kilometres/hour/minute, Kilometres/hour/second, Metre/sec/sec, Centimetres/sec/Sec,
Miles/hour/minute, Miles/hour/second, Yards/sec/sec, Feet/sec/sec, Inches/sec/sec, Int. Nautical Mile/hour/second,
UK Nautical Miles/hour/second
¨ Angle (Plane):
Seconds, Minutes, Degrees, Grads, Octants, Sextants, Radians, Quadrants, Circles, Revolutions, Turns
¨ Angle (Solid):
Steradian, Spherical Right Angle, Hemisphere, Sphere
¨ Area:
Sq Millimetre, Sq Centimetre, Sq Decimetre, Sq Metre, Are, Hectare, Sq Kilometre, Sq Inch, Sq Foot, Sq Yard, Sq
Furlong, Sq Mile, Acre, Int. sq Nautical Mile, UK sq Nautical Mile
¨ Distance; Length:
Angstrom, Micron, Millimetre, Centimetre, Decimetre, metre, Hectometre, Kilometre, Thou, Mil, Inch, Foot, Yard,
Furlong, Mile, Fathom, Int. Nautical Mile, UK Nautical Mile, Light-year, Parsec
¨ Illumination:
Foot-candles, Lux, Meter-candles
¨ Moment; Torque:
Newtons millimetre, Newtons centimetre, Newtons metre (Joule), Kilonewtons millimetre, Kilonewtons centimetre,
Kilonewtons metre, Kilogram millimetre, Kilogram centimetre, Kilograms metre, Tonnes millimetre, Tonnes
centimetre, Tonnes metre, Pounds inch, Pounds foot, Pounds yard, Kips inch, Kips foot, Kips yard, Tons inch, Tons
foot, Tons yard
¨ Moment of Inertia:
Millimetre4, Centimetre4, Decimetre4, Metre4, Hectometre4, Kilometre4, Inch4, Foot4, Yard4, Furlong4, Mile4
¨ Power:
Calories/second, Kilocalories/hour, Pound-feet/minute, Pound-feet/second, BTU/hour, BTU/minute, BTU/seconds,
Horsepower, Horsepower (metric), kgf metre/second, Watts (Joules/second), Kilowatts, Megawatts
¨ Section Modulus:
Millimetre3, Centimetre3, Decimetre3, Metre3, Hectometre3, Kilometre3, Inch3, Foot3, Yard3, Furlong3, Mile3
¨ Speed; Velocity (Linear):
Centimetres/hour, Centimetres/minute, Centimetres/second, Metres/hour, Metres/minute, Metres/second,
Kilometres/hour, Kilometres/minute, Kilometres/second, Int. Knots, UK Knots, C, Mach, Inches/hour, Inches/minute,
Inches/second, Feet/hour, Feet/minute, Feet/second, Yards/hour, Yards/minute, Yards/second, Miles/hour (mph),
Miles/minute, Miles/second
¨ Velocity (Angular):
Degrees/second, Radians/second, Revolutions (cycles)/minute [rpm], Revolutions (cycles)/second [Hz, cps]
¨ Temperature:
Fahrenheit, Celsius, Kelvin
¨ Time:
Nanoseconds, Milliseconds, Seconds, Minutes, Hours, Days, Weeks, Fortnights, Months, Years, Decades, Lunar
Months, Lunar Years, Centuries, Millenniums
¨ Viscosity (Dynamic):
Micro N s / m^2, kg / m h, mN s / m^2 [g / m s] [Centipoise], Dyn s / cm^ 2 [1 g / cm s] [Poise], N s / m^ 2 [ kg / m s],
kgf s / m^ 2, lb / ft h, pdl s / ft^2 [lb / ft s], lbf s / ft ^ 2 [slug / ft s], lbf h / ft^2
¨ Viscosity (Kinematic):
mm ^2 / h, mm ^2 / s [Centistoke], cm ^2 / h, cm ^2 / s [Stoke], m ^2 / h, m ^2 / s, in ^2 / h, in ^2 / s, ft ^2 / h, ft ^2 / s
¨ Volume:
Cu Millimetre, Cu Centimetre, Cu Decimetre, Cu Metre, Cu Hectometre, Cu Kilometre, Stere, Millilitre (CC), Centilitre,
Decilitre, Litre, Hectolitre, Kilolitre, Cu Inch, Cu Foot, Cu Yard, Cu Furlong, Cu Mile, UK Fluid Ounce, UK Gill, UK
Pint, UK Quart, UK Gallon, UK Peck, UK Bushel, Teaspoon, Tablespoon, US Fluid Ounce, Cup, US Pint, US Quart,
US Gallon, US Barrel, US Pint Dry, US Quart Dry, US Peck Dry, US Bushel Dry
Introduction
To allow ready conversation of measurements from one system to the other, it has been
necessary in some tables to group unlike quantities like mass and force. This has been
inevitable due to the difference in fundamental quantities on which the unit systems are
based. In the Metric and SI systems, mass is a fundamental quantity. In the BIS and the
USCS systems, mass is not a fundamental quantity but a derived unit based on force as a
fundamental quantity.
Similar to the mass and weight table, speed and velocity have also been grouped together
in one table. To keep the file size of UnitsCalc small, the fact that velocity has a direction
and speed is directionless has been ignored.
In short, UnitsCalc is a simple tool for the conversion of measurement units in use on the
planet earth. As the mixture of these units employ different fundamental quantities in mass
and force, the user needs to exercise care in using these units correctly. To this end, study
of the next worksheet "Consistent Set of Units" might be found helpful.
To load UnitsCalc on to your computer, copy this file into Microsoft Office folder for its
Templates. Generally the path to this folder in Excel 97 is:
C:\Program Files\Microsoft Office\Templates
If you are using Excel 2000, the path to this folder is:
C:\Windows\Application Data\Microsoft\Templates
If you receive an Excel Warning about running Macros and are prompted for whether to load
them, answer YES to Load and Enable Macros. UnitsCalc incorporates VB Macros and to
allow your computer to use them is vital for its operation.
¨ Loading of UnitsCalc in Excel leads to its Homepage. This page displays command buttons
to all conversion tables and documentation pages in UnitsCalc. Clicking a button displays
any desired conversion table or documentation page.
¨ To convert a measurement from any one unit to its equivalent in rest of the units, type your
value in cell C2 (shaded light green). After pressing enter/return, use a mouse click in any
desired cell of Column-C to select your original unit. The mouse click changes row colour of
your original unit to yellow and instantly converts the measurement in cell C2 to its
equivalents in respective rows of all other units (cells shaded light blue).
¨ To display simple conversion factors from any one unit to rest of the units, you can type a
value of 1 in cell C2 (shaded light green) as your measurement.
¨ To navigate among various conversion tables, click the Home button in top left cell of the
table. This takes you to the Homepage of UnitsCalc for going to other conversion tables.
¨ To copy a converted value to the Clipboard, click its unit name in right column of the
conversion table. This displays a dialog box showing the value copied to the clipboard.
Click OK in this dialog box. The copied value can now be pasted in another worksheet or
application e.g. MS word.
¨ In converse to the above, a conversion value can be pasted in Cell C2 from another
worksheet or application via the clipboard. However, please use the Paste-Special - value
command rather than the simple Paste Command. The Paste command erases the cell
colour and its data validation capability.
¨ When ending a session of UnitsCalc, Excel displays a dialogue box for saving the UnitsCalc
file. Select "NO" to this option as changes to the UnitsCal file do not require saving.
Acceleration
"g" 9.80665 metre/second/second (32.1740485564304 ft/s/s)
gal 1 centimetre/second/second
Angle (Solid)
Sphere A total solid angle about a point = 2 Hemispheres = 8 Spherical right angles = 4 p
Steradians
Steradians The SI unit of solid angle, equal to the angle made at the centre of a sphere by an area on
the surface of the sphere equal to the square of the sphere’s radius. Symbol sr
Area
Are 100 sq m; a unit for area of farmland and real estate
Acre 4840 sq yards
Hectare 10,000 sq metre = 100 Are
Distance; Length
Angstrom Å, a unit of length equal to one hundred-millionth of a centimetre, 10 -10 metre.
Centimetre cm, equal to 0.01 m
Decimetre 0.1 m
Fathom a unit of length equal to six feet, chiefly used in reference to the depth of water.
Foot ft, a unit of linear measure equal to 12 inches (304.8 mm exactly).
Furlong an eighth of a mile, 220 yards
Hectometre a metric unit of length equal to one hundred metres.
Inch in, unit of linear measure equal to one twelfth of a foot, 25.4 mm exactly
Kilometre a metric unit of measurement equal to 1,000 metres
Metre As per 1983 definition, the length of the path travelled by light in a vacuum during a time
interval of 1/299792458 of a second.
Micron one millionth of a metre.
Mile a linear measure equal to 1,760 yards (also statute mile)
Millimetre mm equal to 0.001 m
Calorie Sometimes referred to as a small Calorie, it is the energy needed to raise the temperature of
1 gram of water through 1 °C, now usually defined as equal to 4.1868 joules.
Chu Centigrade heat unit defined as the amount of heat required to raise the temperature of 1 lb
of water through 1 degC at standard temperature and pressure.
Kilocalorie A large calorie, usually referred to simply as a calorie and sometimes as a kilogram calorie,
equals 1000 calories. It is the unit used to express the energy producing value of food in
the calculation of diets.
Force
Dyne It is a unit of force that, acting on a mass of one gram, increases its velocity by one
centimetre per second every second along the direction that it acts (abbr.: dyn).
kilogram force 9.80665 Newtons
Poundal it is a unit of force equal to the force required to give a mass of one pound an acceleration
of one foot per second per second.
Illumination
foot-candle a unit of illumination equal to that given by a source of one candela at a distance of one foot.
lux (lx) SI unit of illuminance, equal to one lumen per square metre.
Power
Horsepower 550 Pound-feet/second (1.013869665 Horsepower metric)
Horsepower 75 kilogram-metre/second (0.986320071 Horsepower)
(metric)
Watt 1 joule/second (0.737562149 lb-ft/second)
Pressure
Atmosphere 101325 N/sq-mm = 760 mm of Mercury
Bar 100000 N/sq-mm
Pascal 1 N/sq-m
Torr 1 mm of Mercury = 133.3223684 Pa
Speed
C The speed of light in a vacuum defined to be exactly 299 792 482 metres per second.
Knot 1852 metres/hour (1.150779448 mph)
(International)
Knot (UK) 6080 feet/hour (1.151515152 mph)
Mach Ratio of the speed of a body to the speed of sound in the surrounding medium, used with a
numeral (as Mach 1, Mach 2, etc.) to indicate the speed of sound, twice the speed of sound,
etc. A value for the speed of sound of 331.46 metres/second in dry air at a temperature of 0
degC has been used in this template.
Fahrenheit Using this temperature scale, water freezes at approximately 32 degF and boils at
approximated 212 degF. It is given by:
T(F) = 9 T(C)/5 + 32 = 9 T(K)/5 - 459.67
Kelvin (K) SI unit for measuring temperature. On the Kelvin scale, water freezes at about 273 K and
boils at approximately 373K. It is given by:
T(K) = 5[T(F) - 32]/9 + 273.15 = T(C) + 273.15
Time
Light-year a unit of distance in Astronomy, equivalent to the distance that light travels in one year,
9.460528263 × 1012 km (about 587.85 million miles).
Lunar Month The lunar or synodic month is the time Moon takes to pass from particular phase, such as
full moon, back to the same phase; its average has been taken as 29 days, 12 hours, 44
minutes and 2.8 seconds or 29.530587962963 days.
Parsec Distance at which the mean radius of the Earth's orbit subtends an angle of one second of
arc. It is used by professional astronomers to express distance to stars and galaxies. One
parsec has been taken as 3.26163408 light-years has been used in this template.
Solar Year It has been taken as 365 days, 5 hours, 48 minutes and 45.5 seconds or
365.242193287037 days (31556925.5 seconds)
Viscosity (Dynamic)
Poise a unit of dynamic viscosity, such that a tangential force of one dyne per square centimetre
causes a velocity change of one centimetre per second between two parallel planes
separated by one centimetre in a liquid.
Unit Symbols
a are (SI)
Å Angstrom
atm standard atmosphere pressure; 1 atm = 101325 Pa
bar bar
cd candela (SI)
cm centimetre
cu cubic foot
dyn dyne = 10-5 N
erg erg = 10-7 J
fps foot per second
Metric Prefixes
ft foot Abbreviations Factors
g gram 1 exa E 1018
h hour = 3600 seconds 2 peta P 1015
ha hectare 3 tera T 1012
hp horsepower, 550 foot-pounds per second 4 giga G 109
Hz cycle (revolutions) per second, cps 5 mega M 106
in inch 6 kilo k 103
7 hecto h 102
J joule 8 deca da 10
K Kelvin 9 deci d 10-1
k kip, USCS 10 centi c 10-2
kg kilogram 11 milli m 10-3
kgf Kilogram force = 9.80665 N on planet earth 12 micro m 10-6
kJ kilojoule 13 nano n 10-9
km Kilometre 14 pico p 10-12
15 femto f 10-15
kN kilonewton
16 atto a 10-18
ksf kip per square foot
ksi kip per square inch
KW kilowatts
l litre
lb pound
lbf pound force
lm lumen
lx Lux
m metre
mm millimetre
mi mile (Imperial, USCS)
mN millinewton = 0.001 N
MJ megajoule
mph mile per hour
MW Megawatts
N Newton
Pa Pascal
pcf pound per cubic foot
pdl Poundal
psf pound per square foot
psi pound per square inch
rad radian
rpm revolutions per minute
s second
sr steradian
tonne t
W watt
In dynamic analysis of structures, it is essential to use a consistent set of units. This means that in
calculations Newton's second law, force equal mass times acceleration, is identically satisfied without
using scale or conversion factors.
In a consistent set of units, one unit of force applied to one unit of mass must equal to one unit of
acceleration i.e.
A correct dynamic analysis demands using consistent units. To avoid errors, Blevins [1] suggests using
any of the following consistent set of units.
It is also possible to use other sets of units. For example, if kN is chosen as the unit of force and one
m/s2 as the unit of acceleration, then the unit of mass must be such that 1 kN of force will accelerate it
at 1 m/s2. The unit of mass that satisfies this criteria is 1 Tonne i.e. 1000 kilograms (Mg).
Reference
1 Blevins, Robert D."Formulas for Natural Frequency and Mode Shape", Krieger Publishing
Company, Malabar, Florida, ISBN 0-89464-894-2, 1995.
File: 495005421.xls Tab: Consistent Units Page 33/35 Date Printed: 10/15/2020
Terms & Conditions of UnitsCalc Use
Disclaimer
No Liability is accepted by Techno Consultants or its software authors for any direct, indirect,
consequential or incidental loss or damage arising out of the software use or any mistakes and
negligence in developing this software. The organisation or person using the software bears all
risks and responsibility for the quality and performance of the software.
Your Usage
The software is intended to help you save time and effort in calculations. Please check and
validate all results carefully. You are responsible and liable for all consequences of its use.
You can freely use this product for your personal or business design work. This product,
however, remains our copyright. You may also reproduce and distribute it provided that each
copy shall be a true and complete copy, including all copyright and trademark notices, and that
such distribution shall not be for commercial purposes.
As a guide towards making a minimum payment, you can register your use of this software.
Doing so shall enable you to become a formal member of our user team. Your details will be
used for sharing information on future software developments via email.
The formal registration fee for each product is £15.00 for individuals and £45.00 for companies.
Add 17.5 percent VAT for registrations based in the UK and EC member states. Please send
cheques payable to:
With your payment please ensure to send us your full details i.e. Name, Company, Postal
Address, Telephone, Fax & Email Address. Acknowledgement will be sent via Email.
You can download software and obtain the latest information from our web site. The web and
email address is:
http:\\www.technouk.com
Email: shaiq@technouk.com
As a back up, you can also use the following web and email addresses:
http:\\www.structures.freeserve.co.uk
Email:shaiq@structures.freeserve.co.uk