G
Grams to Pounds
how do I convert grams to pounds? is there a function for
this? I use Excel 97.
Thanks
this? I use Excel 97.
Thanks
No function, but it can be calculated...
Wp = Wg/453.5924
Wp - Weight in pounds
Wg - Weight in grams
So if you had the weight in grams in cell A1
=A1/453.5924
Of course their is a longer explanation:
You cannot "convert" between grams and pounds since pounds
is generally a unit of "weight" and grams is a unit of "mass".
However, if your just looking to figure out how much chicken you
purchased and aren't launching a spaceship, the above should
work fine.
Dan E
Gene Nygaard said:Gentlemen of the jury, Chicolini here may look like an idiot,
and sound like an idiot, but don't let that fool you: He
really is an idiot.
Groucho Marx
In the first place, you need to understand that "weight" is an
ambiguous word, one with several different meanings. What you need to
distinguish are force and mass.
Second, the pounds we are talking about (the avoirdupois variety) are,
by definition, exactly 0.45359237 kilograms. Those kilograms are, of
course, the SI units of mass. Read the current U.S. law, and a
discussion of the prior U.S. law, and the 1959 international agreement
on the current value, at
http://www.ngs.noaa.gov/PUBS_LIB/FedRegister/FRdoc59-5442.pdf
http://gssp.wva.net/html.common/refine.pdf
Third, there is also a pound force, but that is a recent spinoff. It
is so new, in fact, that a "pound force" is uniquely identified by
that name, because of all the hundreds of different pounds used at
various times and places throughout history, only one has spawned a
force unit of the name name. Those pounds force were never
well-defined units before the turn of the 20th century, when people
first started defining a "standard acceleration of gravity" for this
purpose. Even today, pounds force don't have an "official"
definition; we often borrow the standard acceleration of gravity which
is official for defining kilograms force (9.80665 m/s²), but other
values are used as well, such as 32.16 ft/s² or 386 in/s².
Let's look at the other pounds still in use.
There is also the troy "system of weights." The pound (373.2417216 g)
isn't used much any more, but the ounce (31.1034768 g) is, even in the
21st century enjoying a special exception the metrication laws of
places such as the United Kingdom (where the pound on which it is
based was outlawed back in the 19th century) and Australia. These
troy units of weight are always units of mass, never units of force.
Unlike their avoirdupois cousins, and unlike grams and kilograms, they
have never spun off a force unit of the same name. There is no troy
ounce force, and never has been.
The other pounds (Pfund, livre, libra, pund, etc.) still in use, at
least informally, in several different places in Europe and Latin
America, are the ones redefined back in the 19th century as 500 g
exactly. Half a kilogram. Units of mass.
When you are buying chicken, those pounds are, of course, every bit as
much units of mass as the grams which appear right alongside them on
the labels in the United States, or which are the only units elsewhere
in the world. Pounds force are not legal for this purpose.
It's hard to believe that some people are so God-awful stupid as to
insist that when we buy and sell goods by weight, we'd want to measure
some quantity which varies with location. We should not do so; we do
not do so; we have never done so.
To make it easy for you, here are what some of the real experts in the
field have to say about it, from the official keepers of our
standards, such as the national standards laboratories of the United
States and the United Kingdom:
Here's a FAQ by the NPL, the national standards laboratory of the
U.K.:
http://www.npl.co.uk/force/faqs/forcemassdiffs.html
Weight
In the trading of goods, weight is taken to mean the
same as mass, and is measured in kilograms. Scientifically
however, it is normal to state that the weight of a
body is the gravitational force acting on it and hence
it should be measured in newtons, and this force
depends on the local acceleration due to gravity.
To add to the confusion, a weight (or weightpiece)
is a calibrated mass normally made from a dense
metal, and weighing is generally defined as a
process for determining the mass of an object.
So, unfortunately, weight has three meanings
and care should always be taken to appreciate
which one is meant in a particular context.
Note--they clearly refer to different *meanings* of this word.
Here's NIST, the U.S. national standards agency, in their Guide for
the Use of the International System of Units, NIST Special Publication
811,
http://physics.nist.gov/Pubs/SP811/sec08.html
In commercial and everyday use, and especially in common
parlance, weight is usually used as a synonym for mass.
Thus the SI unit of the quantity weight used in this
sense is the kilogram (kg) and the verb "to weigh" means
"to determine the mass of" or "to have a mass of".
Examples: the child's weight is 23 kg
the briefcase weighs 6 kg
Net wt. 227 g
Note especially that last one--this is the proper usage for the sale
of chicken.
The National Standard of Canada, CAN/CSA-Z234.1-89 Canadian Metric
Practice Guide, January 1989:
5.7.3 Considerable confusion exists in the use of the
term "weight." In commercial and everyday use, the
term "weight" nearly always means mass. In science
and technology, "weight" has primarily meant a force
due to gravity. In scientific and technical work, the
term "weight" should be replaced by the term "mass"
or "force," depending on the application.
5.7.4 The use of the verb "to weigh" meaning "to
determine the mass of," e.g., "I weighed this object
and determined its mass to be 5 kg," is correct.
The thing to note here is the different treatment of the noun forms
and the verb forms, Contrast the application dependent meanings of
the former with the unqualified "is correct" in the latter.
The other thing to note is that "nearly always" is much stronger than
"primarily"--they even got that part correct.
5.7.4 The use of the verb "to weigh" meaning "to
determine the mass of," e.g., "I weighed this object
and determined its mass to be 5 kg," is correct.
Like the experts tell you, you are best off avoiding the word "weight"
in a technical context, and if you do use it, you need to make clear
which meaning is intended.
Gene Nygaard
http://ourworld.compuserve.com/homepages/Gene_Nygaard/t_jeff.htm
But if it be thought that, either now, or at any future time, the
citizens of the United States may be induced to undertake a thorough
reformation of their whole system of measures, weights and coins,
reducing every branch to the same decimal ratio already established
in their coins, and thus bringing the calculation of the principal
affairs of life within the arithmetic of every man who can multiply
and divide plain numbers, greater changes will be necessary.
U.S. Secretary of State Thomas Jefferson, 1790
Meanings of weight
From the columbia encyclopedia
1. measure of the force of gravity on a body (see gravitation). Since the
weights of different bodies at the same location are proportional to their
masses, weight is often used as a measure of mass. However, the two
are not the same; mass is a measure of the amount of matter present
in a body and thus has the same value at different locations, and weight
varies depending upon the location of the body in the earth's gravitational
field (or the gravitational field of some other astronomical body). A given
body will have the same mass on the earth and on the moon, but its
weight on the moon will be only about 16% of the weight as measured on
the earth. The distinction between weight and mass is further confused
by the use of the same units to measure both-the pound, the gram, or
the kilogram. One pound of weight, or force, is the force necessary at a
given location to accelerate a one-pound mass at a rate equal to the
acceleration of gravity at that location (about 32 ft per sec per sec).
Similar relationships hold between the gram of force and the gram of
mass and between the kilogram of force and the kilogram of mass.
---> Very clear on it's meaning of FORCE
Merriam Webster Dictionary
1 ---> irrelevent
2 a : a quantity or thing weighing a fixed and usually specified amount
b : a heavy object (as a metal ball) thrown, put, or lifted as an athletic
exercise or contest
---> Defenition missed by all your sources.
3 a : a unit of weight or mass -- see METRIC SYSTEM table
b : a
piece of material (as metal) of known specified weight for use in
weighing articles
c : a system of related units of weight
---> Unit of weight (clearly refering to force as it's distinguished from mass)
4 a : something heavy : LOAD
b : a heavy object to hold or press
something down or to counterbalance
---> One your sources got
5 ---> irrelevent
6 a : relative heaviness : MASS
b : the force with which a body is attracted
toward the earth or a celestial body by gravitation and which is equal to the
product of the mass and the local gravitational acceleration
---> Clearly referring to FORCE
What? Read it.7 ---> irrelevent
8 : overpowering force
---> Again clearly referring to FORCE
9 ---> irrelevent
10 ---> irrelevent
11 --->irrelevent
Looks to me like they're re-defining the pound (creating a new meaning)
for a unit that's been around for centuries.
Besides, why would we be
referring to that i'd prefer to talk about the british system, that's
the one the US system is based on.
The british pound is a measure
of force and always has been. I'm not an american so I could care less
about the US "Imperial" system.
Pound-force as you call it is a recent definition by the US of the
british pound after re-working their pound to be a unit of mass. The
pund is and was a unit of force in said british system.
OK, i'll believe you, luckily for you and others confused by mass and force
1 lbm exerts 1lbf, just as 1 kgm exerts 1kgf.
***********************************************************************************
Above you refer to weight to mean FORCE, you've just proved my point.
Scales (all scales) by the very nature of "weighing" measure a force exerted
on the surface of the scale. It can then be converted to a mass, again,
luckily 1 lbm exerts 1 lbf and 1 kgm exerts 1 kgf.
If your not using a scale you will need to determine the volume, and density
of the object in order to calculate it's mass. And I doubt that's how anyone
is doing it.
Weight "is taken to mean" so it doesn't mean mass it's just being
interpreted as mass.
Weight has more than three meanings, unfortutely for them none
of the meanings is MASS
Yes and in all cases the objects were likely weighed (had the force they
excert on a scale measured)
Please reference the source stating that "nearly always" is a stronger
use of language than "primarily". I would say it's vice versa
Synonyms for primarily:
first and foremost
above all
chiefly
mainly
principally
for the most part
mostly
largely
predominantly
So weigh means to determine the mass of
By their definition they should say "I weighed this object to be 5 kg"
which sounds quite absurd.
There should be no need to qualify that statement with "and
determined its mass" if indeed weigh does mean what they take it
to mean.
Re-work
To weigh -> To determine the force which an object exerts
I weighed this object and determined it's mass to be 5kg
-> you weigh the object then determine it's mass by converting
the weight (force) to a mass using the local gravitational constant.
Even you don't follow that rule look for *********** above
At your site I notice you mention it's mostly engineers and physicists
mistaken on this point. When in all reality these are the people getting
space ships off of the ground. Therefore I will assume that it's laypeople
confused on this issue and not the people who deal with weights (forces)
and mass on a technical level daily.
Finally, next time you read a pressure make sure you qualify it it as
pounds force per square inch. I won't be doing that but you really should.