calculate moles in excel

HELP!

How in Excel do I work out how many moles are in 1kg of water. Desperately
need an answer for Monday morning.

:)

MikeH
Sat May 10 16:15:00 CDT 2008

Hi,

So it's homework time is it?

Firstly you can't do it solely in Excel without reference to a table of
atomic weights and from that you should discover the following:-

Hydrogen atomic weight = 1.0079
Oxygen atomic weight = 15.994
Put these 2 values in A1(hydrogen) and A2(oxygen)
Now work out number of moles with this formula
=1000/(A1*2+A2)

To make it more flexible you could put the 1000gms in a cell and reference
it in the formula
=A3/(A1*2+A2)


Mike


"Dave" wrote:

> HELP!
>
> How in Excel do I work out how many moles are in 1kg of water. Desperately
> need an answer for Monday morning.
>
> :)

Dave
Sat May 10 16:25:00 CDT 2008

OK I understand that but my Chem tutor keeps rattling on about avagardos
constant and I thought i need that to work out moles

"Mike H" wrote:

> Hi,
>
> So it's homework time is it?
>
> Firstly you can't do it solely in Excel without reference to a table of
> atomic weights and from that you should discover the following:-
>
> Hydrogen atomic weight = 1.0079
> Oxygen atomic weight = 15.994
> Put these 2 values in A1(hydrogen) and A2(oxygen)
> Now work out number of moles with this formula
> =1000/(A1*2+A2)
>
> To make it more flexible you could put the 1000gms in a cell and reference
> it in the formula
> =A3/(A1*2+A2)
>
>
> Mike
>
>
> "Dave" wrote:
>
> > HELP!
> >
> > How in Excel do I work out how many moles are in 1kg of water. Desperately
> > need an answer for Monday morning.
> >
> > :)

MikeH
Sat May 10 16:43:00 CDT 2008

Hi,

It's actually Avagadro's constant and you don't need to know that to work
out moles but it would be well to understand it.

I'm aware we are stepping over the boundary here from excel to chemistry and
I'm no expert in either but here we go.

Avagadro's constant is a number that is the amount of units of a thing that
are in 1 mole of that thing and I use 'thing' because there is no standard
unit for it.

The constant is actually 6.022 *10^23 (which is a very big number). So 1
mole of computers is 6.022 * 10^23 computers, 1 mole of Excel MVP's is 6.022
* 10^23 MVP's and for 1 mole of water we do the same sum.

So to get back to your question 1000gms of water is roughly 55.52 moles so
multiply that by Avagadro's constant and that's how many molecules of H2O are
in 1000gms of water.


Mike

"Dave" wrote:

> OK I understand that but my Chem tutor keeps rattling on about avagardos
> constant and I thought i need that to work out moles
>
> "Mike H" wrote:
>
> > Hi,
> >
> > So it's homework time is it?
> >
> > Firstly you can't do it solely in Excel without reference to a table of
> > atomic weights and from that you should discover the following:-
> >
> > Hydrogen atomic weight = 1.0079
> > Oxygen atomic weight = 15.994
> > Put these 2 values in A1(hydrogen) and A2(oxygen)
> > Now work out number of moles with this formula
> > =1000/(A1*2+A2)
> >
> > To make it more flexible you could put the 1000gms in a cell and reference
> > it in the formula
> > =A3/(A1*2+A2)
> >
> >
> > Mike
> >
> >
> > "Dave" wrote:
> >
> > > HELP!
> > >
> > > How in Excel do I work out how many moles are in 1kg of water. Desperately
> > > need an answer for Monday morning.
> > >
> > > :)

Gord
Sat May 10 19:28:33 CDT 2008

The proper spelling is Avagadro's Constant and can be found by searching
the 'net.

I sincerely hope your instructor did not teach you "avagardos constant"


Gord Dibben MS Excel MVP

On Sat, 10 May 2008 14:25:00 -0700, Dave <Dave@discussions.microsoft.com> wrote:

>OK I understand that but my Chem tutor keeps rattling on about avagardos
>constant and I thought i need that to work out moles
>
>"Mike H" wrote:
>
>> Hi,
>>
>> So it's homework time is it?
>>
>> Firstly you can't do it solely in Excel without reference to a table of
>> atomic weights and from that you should discover the following:-
>>
>> Hydrogen atomic weight = 1.0079
>> Oxygen atomic weight = 15.994
>> Put these 2 values in A1(hydrogen) and A2(oxygen)
>> Now work out number of moles with this formula
>> =1000/(A1*2+A2)
>>
>> To make it more flexible you could put the 1000gms in a cell and reference
>> it in the formula
>> =A3/(A1*2+A2)
>>
>>
>> Mike
>>
>>
>> "Dave" wrote:
>>
>> > HELP!
>> >
>> > How in Excel do I work out how many moles are in 1kg of water. Desperately
>> > need an answer for Monday morning.
>> >
>> > :)

HelpFrom
Sat May 10 22:01:01 CDT 2008

Considering the quality of the ability, or lack thereof, of today's college
graduates to even formulate a proper sentence, I think chances are probably
about 50/50 that he was taught avagardos constant instead of Avagadro's
Constant.

Can't put all the blame on the student when the faculty and administrators
keep lowering standards to make sure no child suffers the terrible,
life-long-lasting stigma of actually being held back a year until they learn
what everyone else did.

"Gord Dibben" wrote:

> The proper spelling is Avagadro's Constant and can be found by searching
> the 'net.
>
> I sincerely hope your instructor did not teach you "avagardos constant"
>
>
> Gord Dibben MS Excel MVP
>
> On Sat, 10 May 2008 14:25:00 -0700, Dave <Dave@discussions.microsoft.com> wrote:
>
> >OK I understand that but my Chem tutor keeps rattling on about avagardos
> >constant and I thought i need that to work out moles
> >
> >"Mike H" wrote:
> >
> >> Hi,
> >>
> >> So it's homework time is it?
> >>
> >> Firstly you can't do it solely in Excel without reference to a table of
> >> atomic weights and from that you should discover the following:-
> >>
> >> Hydrogen atomic weight = 1.0079
> >> Oxygen atomic weight = 15.994
> >> Put these 2 values in A1(hydrogen) and A2(oxygen)
> >> Now work out number of moles with this formula
> >> =1000/(A1*2+A2)
> >>
> >> To make it more flexible you could put the 1000gms in a cell and reference
> >> it in the formula
> >> =A3/(A1*2+A2)
> >>
> >>
> >> Mike
> >>
> >>
> >> "Dave" wrote:
> >>
> >> > HELP!
> >> >
> >> > How in Excel do I work out how many moles are in 1kg of water. Desperately
> >> > need an answer for Monday morning.
> >> >
> >> > :)
>
>

Gord
Sat May 10 22:16:12 CDT 2008

Unfortunately, I think you may be right Jerry

I am positive that not all the posters with the spelling and grammatical
mistakes are high school or grade school drop-outs.


Gord

On Sat, 10 May 2008 20:01:01 -0700, JLatham <HelpFrom @
Jlathamsite.com.(removethis)> wrote:

>Considering the quality of the ability, or lack thereof, of today's college
>graduates to even formulate a proper sentence, I think chances are probably
>about 50/50 that he was taught avagardos constant instead of Avagadro's
>Constant.
>
>Can't put all the blame on the student when the faculty and administrators
>keep lowering standards to make sure no child suffers the terrible,
>life-long-lasting stigma of actually being held back a year until they learn
>what everyone else did.
>
>"Gord Dibben" wrote:
>
>> The proper spelling is Avagadro's Constant and can be found by searching
>> the 'net.
>>
>> I sincerely hope your instructor did not teach you "avagardos constant"
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Sat, 10 May 2008 14:25:00 -0700, Dave <Dave@discussions.microsoft.com> wrote:
>>
>> >OK I understand that but my Chem tutor keeps rattling on about avagardos
>> >constant and I thought i need that to work out moles
>> >
>> >"Mike H" wrote:
>> >
>> >> Hi,
>> >>
>> >> So it's homework time is it?
>> >>
>> >> Firstly you can't do it solely in Excel without reference to a table of
>> >> atomic weights and from that you should discover the following:-
>> >>
>> >> Hydrogen atomic weight = 1.0079
>> >> Oxygen atomic weight = 15.994
>> >> Put these 2 values in A1(hydrogen) and A2(oxygen)
>> >> Now work out number of moles with this formula
>> >> =1000/(A1*2+A2)
>> >>
>> >> To make it more flexible you could put the 1000gms in a cell and reference
>> >> it in the formula
>> >> =A3/(A1*2+A2)
>> >>
>> >>
>> >> Mike
>> >>
>> >>
>> >> "Dave" wrote:
>> >>
>> >> > HELP!
>> >> >
>> >> > How in Excel do I work out how many moles are in 1kg of water. Desperately
>> >> > need an answer for Monday morning.
>> >> >
>> >> > :)
>>
>>

Ken
Sat May 10 23:57:40 CDT 2008

On May 11, 10:28 am, Gord Dibben <gorddibbATshawDOTca> wrote:
> The proper spelling is Avagadro's Constant and can be found by searching
> the 'net.
>
> I sincerely hope your instructor did not teach you "avagardos constant"
>
> Gord Dibben MS Excel MVP
>
> On Sat, 10 May 2008 14:25:00 -0700, Dave <D...@discussions.microsoft.com> wrote:
> >OK I understand that but my Chem tutor keeps rattling on about avagardos
> >constant and I thought i need that to work out moles
>
> >"Mike H" wrote:
>
> >> Hi,
>
> >> So it's homework time is it?
>
> >> Firstly you can't do it solely in Excel without reference to a table of
> >> atomic weights and from that you should discover the following:-
>
> >> Hydrogen atomic weight = 1.0079
> >> Oxygen atomic weight = 15.994
> >> Put these 2 values in A1(hydrogen) and A2(oxygen)
> >> Now work out number of moles with this formula
> >> =1000/(A1*2+A2)
>
> >> To make it more flexible you could put the 1000gms in a cell and reference
> >> it in the formula
> >> =A3/(A1*2+A2)
>
> >> Mike
>
> >> "Dave" wrote:
>
> >> > HELP!
>
> >> > How in Excel do I work out how many moles are in 1kg of water. Desperately
> >> > need an answer for Monday morning.
>
> >> > :)

But it's Avogadro.

Ken Johnson

HelpFrom
Sun May 11 00:50:01 CDT 2008

Damn! Good thing I didn't choose kimystery as a major! Thanks for the
correction to the correction, seriously.

How odd that I should have forgotten how to spell it after only about 40
years of never so much as using it in a sentence or uttering it in
conversation.

"Ken Johnson" wrote:

> On May 11, 10:28 am, Gord Dibben <gorddibbATshawDOTca> wrote:
> > The proper spelling is Avagadro's Constant and can be found by searching
> > the 'net.
> >
> > I sincerely hope your instructor did not teach you "avagardos constant"
> >
> > Gord Dibben MS Excel MVP
> >
> > On Sat, 10 May 2008 14:25:00 -0700, Dave <D...@discussions.microsoft.com> wrote:
> > >OK I understand that but my Chem tutor keeps rattling on about avagardos
> > >constant and I thought i need that to work out moles
> >
> > >"Mike H" wrote:
> >
> > >> Hi,
> >
> > >> So it's homework time is it?
> >
> > >> Firstly you can't do it solely in Excel without reference to a table of
> > >> atomic weights and from that you should discover the following:-
> >
> > >> Hydrogen atomic weight = 1.0079
> > >> Oxygen atomic weight = 15.994
> > >> Put these 2 values in A1(hydrogen) and A2(oxygen)
> > >> Now work out number of moles with this formula
> > >> =1000/(A1*2+A2)
> >
> > >> To make it more flexible you could put the 1000gms in a cell and reference
> > >> it in the formula
> > >> =A3/(A1*2+A2)
> >
> > >> Mike
> >
> > >> "Dave" wrote:
> >
> > >> > HELP!
> >
> > >> > How in Excel do I work out how many moles are in 1kg of water. Desperately
> > >> > need an answer for Monday morning.
> >
> > >> > :)
>
> But it's Avogadro.
>
> Ken Johnson
>

MikeH
Sun May 11 02:54:01 CDT 2008

Hi,

Now that's interesting, both yourself and GD discuss high/grade school which
I guess are US terms and then comment on standards making the assumption; I
think, that this guy is from the US. Me, I'm convinced he's English, the
problem is pandemic.

Mike

"JLatham" wrote:

> Damn! Good thing I didn't choose kimystery as a major! Thanks for the
> correction to the correction, seriously.
>
> How odd that I should have forgotten how to spell it after only about 40
> years of never so much as using it in a sentence or uttering it in
> conversation.
>
> "Ken Johnson" wrote:
>
> > On May 11, 10:28 am, Gord Dibben <gorddibbATshawDOTca> wrote:
> > > The proper spelling is Avagadro's Constant and can be found by searching
> > > the 'net.
> > >
> > > I sincerely hope your instructor did not teach you "avagardos constant"
> > >
> > > Gord Dibben MS Excel MVP
> > >
> > > On Sat, 10 May 2008 14:25:00 -0700, Dave <D...@discussions.microsoft.com> wrote:
> > > >OK I understand that but my Chem tutor keeps rattling on about avagardos
> > > >constant and I thought i need that to work out moles
> > >
> > > >"Mike H" wrote:
> > >
> > > >> Hi,
> > >
> > > >> So it's homework time is it?
> > >
> > > >> Firstly you can't do it solely in Excel without reference to a table of
> > > >> atomic weights and from that you should discover the following:-
> > >
> > > >> Hydrogen atomic weight = 1.0079
> > > >> Oxygen atomic weight = 15.994
> > > >> Put these 2 values in A1(hydrogen) and A2(oxygen)
> > > >> Now work out number of moles with this formula
> > > >> =1000/(A1*2+A2)
> > >
> > > >> To make it more flexible you could put the 1000gms in a cell and reference
> > > >> it in the formula
> > > >> =A3/(A1*2+A2)
> > >
> > > >> Mike
> > >
> > > >> "Dave" wrote:
> > >
> > > >> > HELP!
> > >
> > > >> > How in Excel do I work out how many moles are in 1kg of water. Desperately
> > > >> > need an answer for Monday morning.
> > >
> > > >> > :)
> >
> > But it's Avogadro.
> >
> > Ken Johnson
> >

MikeH
Sun May 11 03:16:00 CDT 2008

Ken,

Interesting point. There are probably as many references to Avagadro as
Avogadro on the net and in textbooks but what we can agree on completely is
that it isn't avagardo and a man of such eminence; at the very least,
deserves his name to be spelt with a capital A.

Mike


"Ken Johnson" wrote:

> On May 11, 10:28 am, Gord Dibben <gorddibbATshawDOTca> wrote:
> > The proper spelling is Avagadro's Constant and can be found by searching
> > the 'net.
> >
> > I sincerely hope your instructor did not teach you "avagardos constant"
> >
> > Gord Dibben MS Excel MVP
> >
> > On Sat, 10 May 2008 14:25:00 -0700, Dave <D...@discussions.microsoft.com> wrote:
> > >OK I understand that but my Chem tutor keeps rattling on about avagardos
> > >constant and I thought i need that to work out moles
> >
> > >"Mike H" wrote:
> >
> > >> Hi,
> >
> > >> So it's homework time is it?
> >
> > >> Firstly you can't do it solely in Excel without reference to a table of
> > >> atomic weights and from that you should discover the following:-
> >
> > >> Hydrogen atomic weight = 1.0079
> > >> Oxygen atomic weight = 15.994
> > >> Put these 2 values in A1(hydrogen) and A2(oxygen)
> > >> Now work out number of moles with this formula
> > >> =1000/(A1*2+A2)
> >
> > >> To make it more flexible you could put the 1000gms in a cell and reference
> > >> it in the formula
> > >> =A3/(A1*2+A2)
> >
> > >> Mike
> >
> > >> "Dave" wrote:
> >
> > >> > HELP!
> >
> > >> > How in Excel do I work out how many moles are in 1kg of water. Desperately
> > >> > need an answer for Monday morning.
> >
> > >> > :)
>
> But it's Avogadro.
>
> Ken Johnson
>

HelpFrom
Sun May 11 07:33:01 CDT 2008

Thank goodness he got an answer earlier, because we've certainly not only
hijacked his thread, but thoroughly derailed it!

I haven't been abroad for some years now, so I wasn't aware that this was
becoming, or has become, such a widespread condition. I just thought that
store clerks who cannot calculate change on a sale in their head, engineers
who stare blankly at a sliderule, and people who are so clueless to the
geography of their own area that they don't know which side of the largest
river in their country they live on was an American disaster. I must get out
more.

"Mike H" wrote:

> Hi,
>
> Now that's interesting, both yourself and GD discuss high/grade school which
> I guess are US terms and then comment on standards making the assumption; I
> think, that this guy is from the US. Me, I'm convinced he's English, the
> problem is pandemic.
>
> Mike
>
> "JLatham" wrote:
>
> > Damn! Good thing I didn't choose kimystery as a major! Thanks for the
> > correction to the correction, seriously.
> >
> > How odd that I should have forgotten how to spell it after only about 40
> > years of never so much as using it in a sentence or uttering it in
> > conversation.
> >
> > "Ken Johnson" wrote:
> >
> > > On May 11, 10:28 am, Gord Dibben <gorddibbATshawDOTca> wrote:
> > > > The proper spelling is Avagadro's Constant and can be found by searching
> > > > the 'net.
> > > >
> > > > I sincerely hope your instructor did not teach you "avagardos constant"
> > > >
> > > > Gord Dibben MS Excel MVP
> > > >
> > > > On Sat, 10 May 2008 14:25:00 -0700, Dave <D...@discussions.microsoft.com> wrote:
> > > > >OK I understand that but my Chem tutor keeps rattling on about avagardos
> > > > >constant and I thought i need that to work out moles
> > > >
> > > > >"Mike H" wrote:
> > > >
> > > > >> Hi,
> > > >
> > > > >> So it's homework time is it?
> > > >
> > > > >> Firstly you can't do it solely in Excel without reference to a table of
> > > > >> atomic weights and from that you should discover the following:-
> > > >
> > > > >> Hydrogen atomic weight = 1.0079
> > > > >> Oxygen atomic weight = 15.994
> > > > >> Put these 2 values in A1(hydrogen) and A2(oxygen)
> > > > >> Now work out number of moles with this formula
> > > > >> =1000/(A1*2+A2)
> > > >
> > > > >> To make it more flexible you could put the 1000gms in a cell and reference
> > > > >> it in the formula
> > > > >> =A3/(A1*2+A2)
> > > >
> > > > >> Mike
> > > >
> > > > >> "Dave" wrote:
> > > >
> > > > >> > HELP!
> > > >
> > > > >> > How in Excel do I work out how many moles are in 1kg of water. Desperately
> > > > >> > need an answer for Monday morning.
> > > >
> > > > >> > :)
> > >
> > > But it's Avogadro.
> > >
> > > Ken Johnson
> > >

Ken
Sun May 11 09:49:22 CDT 2008

On May 11, 6:16 pm, Mike H <Mi...@discussions.microsoft.com> wrote:
> Ken,
>
> Interesting point. There are probably as many references to Avagadro as
> Avogadro on the net and in textbooks but what we can agree on completely is
> that it isn't avagardo and a man of such eminence; at the very least,
> deserves his name to be spelt with a capital A.
>
> Mike
>
> "Ken Johnson" wrote:
> > On May 11, 10:28 am, Gord Dibben <gorddibbATshawDOTca> wrote:
> > > The proper spelling is Avagadro's Constant and can be found by searching
> > > the 'net.
>
> > > I sincerely hope your instructor did not teach you "avagardos constant"
>
> > > Gord Dibben MS Excel MVP
>
> > > On Sat, 10 May 2008 14:25:00 -0700, Dave <D...@discussions.microsoft.com> wrote:
> > > >OK I understand that but my Chem tutor keeps rattling on about avagardos
> > > >constant and I thought i need that to work out moles
>
> > > >"Mike H" wrote:
>
> > > >> Hi,
>
> > > >> So it's homework time is it?
>
> > > >> Firstly you can't do it solely in Excel without reference to a table of
> > > >> atomic weights and from that you should discover the following:-
>
> > > >> Hydrogen atomic weight = 1.0079
> > > >> Oxygen atomic weight = 15.994
> > > >> Put these 2 values in A1(hydrogen) and A2(oxygen)
> > > >> Now work out number of moles with this formula
> > > >> =1000/(A1*2+A2)
>
> > > >> To make it more flexible you could put the 1000gms in a cell and reference
> > > >> it in the formula
> > > >> =A3/(A1*2+A2)
>
> > > >> Mike
>
> > > >> "Dave" wrote:
>
> > > >> > HELP!
>
> > > >> > How in Excel do I work out how many moles are in 1kg of water. Desperately
> > > >> > need an answer for Monday morning.
>
> > > >> > :)
>
> > But it's Avogadro.
>
> > Ken Johnson

Mike,

Very interesting. I had no idea so many people have been getting it
wrong.

Ken Johnson

Gord
Sun May 11 10:47:27 CDT 2008

I started it by correcting OP incorrectly.

But in my defense, the name can be found with either spelling.

http://en.wikipedia.org/wiki/Avogadro's_number

http://richardbowles.tripod.com/chemistry/moles/moles.htm


Gord

On Sun, 11 May 2008 07:49:22 -0700 (PDT), Ken Johnson <KenCJohnson@gmail.com>
wrote:

>Very interesting. I had no idea so many people have been getting it
>wrong.
>
>Ken Johnson

HelpFrom
Sun May 11 15:20:00 CDT 2008

"I started it...." --- G.D.

Let's just take the root of all this evil out back and simply shoot him! :)


"Gord Dibben" wrote:

> I started it by correcting OP incorrectly.
>
> But in my defense, the name can be found with either spelling.
>
> http://en.wikipedia.org/wiki/Avogadro's_number
>
> http://richardbowles.tripod.com/chemistry/moles/moles.htm
>
>
> Gord
>
> On Sun, 11 May 2008 07:49:22 -0700 (PDT), Ken Johnson <KenCJohnson@gmail.com>
> wrote:
>
> >Very interesting. I had no idea so many people have been getting it
> >wrong.
> >
> >Ken Johnson
>
>

James
Sun May 11 16:11:01 CDT 2008

Mike wrote on Sun, 11 May 2008 01:16:00 -0700:

> Interesting point. There are probably as many references to
> Avagadro as Avogadro on the net and in textbooks but what we
> can agree on completely is that it isn't avagardo and a man of
> such eminence; at the very least, deserves his name to be
> spelt with a capital A.

> Mike

Well, the Google count is 454 000 for Avogadro and 38 000 for
Avagadro. So, if a good number do get it wrong, most don't
(92%). I wonder if a number of us ancients are confused by a
long-standing admiration for the actress Ava Gardner? :-)

Just to confuse things, an actual value of Avogadro's number was
first calculated by J.J. Loschmidt and some people, especially
in Germany, distinguish between "Avogadro's Hypothesis" and the
"Loschmidt Number".
--

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not