Google Answers Logo
View Question
 
Q: Excel function / Add in for Molecular weight. ( Answered,   2 Comments )
Question  
Subject: Excel function / Add in for Molecular weight.
Category: Science
Asked by: tday01-ga
List Price: $5.00
Posted: 30 Jun 2006 14:18 PDT
Expires: 30 Jul 2006 14:18 PDT
Question ID: 742428
I am looking for an add in or macro in Excel that creates a function
that will take a chemical formula as the argument and return the
molecular weight.  E.g. =CHEMWT(H2O)  returns "18".  I have so far
only managed to fins one and it didn't run under the latest version of
Excel.

Clarification of Question by tday01-ga on 03 Jul 2006 12:08 PDT
Unfortunately, i deleted the one I found and can't find it again.  It
claimed to run under '97 Mac.  I am running Excel 2003 under Windows
XP.

Request for Question Clarification by hummer-ga on 03 Jul 2006 13:02 PDT
Hi tday01,

Is this suitable?

MwCalc 
Molecular Weight Calculator 
A free add-in for spreadsheets 
"ChemicaLogic's Molecular Weight Calculator is a free add-in for
spreadsheets that you can use to calculate the molecular weight of
chemicals. This handy function takes a single string argument which is
the chemical formula (or a cell reference containing the chemical
formula) and returns the molecular weight.
No more looking up molecular weights! Download now. Molecular weight
calculator is available for:
? Excel 95/97/2000/XP for Windows 95/98/NT4/XP" 
http://www.chemicalogic.com/mwcalc/
or
http://64.233.167.104/search?q=cache:VcVz0Pi8ctMJ:www.chemicalogic.com/mwcalc/+xp+excel+calculate+molecular+weight+of+chemicals&hl=en&gl=ca&ct=clnk&cd=1&client=firefox-a

Regards,
hummer

Clarification of Question by tday01-ga on 04 Jul 2006 16:28 PDT
Hi Hummer0ga,

This one looks perfect, but for the life of me I can't download it. 
This page behaves as if it is itself a downloadable file.  Can you
download this add-in?

Tony

Request for Question Clarification by hummer-ga on 04 Jul 2006 17:02 PDT
Hi Tony,

I found it a bit weird too, I was hoping it would work for you. I'm
reluctant to do any testing here because I'm on an old computer
(1998!) and dial-up. Maybe one of these will work?

MW Calc v1.3
http://www.the-gibson-family.co.uk/software/mwcalc/mwcalc.html

MW Calc 6.0.1
http://www.tucows.com/get/34675_20428

Molecular Weight Calc 4.6
http://www.tucows.com/get/33301_20358

MWCalc
http://sourceforge.net/projects/mwcalc/

Good luck!
hummer

Clarification of Question by tday01-ga on 14 Jul 2006 14:37 PDT
That's great.  I tried the download with Explorer and it worked fine.
The function works.  Hummer-GA you can claim your $5.  And thanks to
eestudent for finding the weird FireFox bug.

Tony
Answer  
Subject: Re: Excel function / Add in for Molecular weight.
Answered By: hummer-ga on 14 Jul 2006 18:39 PDT
 
Hi Tony,

Thank you for giving me the opportunity to post my answer, I
appreciate it.  Funny the weirdness turned out to be Firefox (thank
you,  eestudent!), who would've thought? Here it is again to make it
official -

MwCalc 
Molecular Weight Calculator 
A free add-in for spreadsheets 
"ChemicaLogic's Molecular Weight Calculator is a free add-in for
spreadsheets that you can use to calculate the molecular weight of
chemicals. This handy function takes a single string argument which is
the chemical formula (or a cell reference containing the chemical
formula) and returns the molecular weight.
No more looking up molecular weights! Download now. Molecular weight
calculator is available for:
? Excel 95/97/2000/XP for Windows 95/98/NT4/XP" 
http://www.chemicalogic.com/mwcalc/

Happy calculating,
hummer
Comments  
Subject: Re: Excel function / Add in for Molecular weight.
From: hammer-ga on 30 Jun 2006 16:05 PDT
 
It would help if you tell us which one you already found, so we don't
look at the same one.

- Hammer
Subject: Re: Excel function / Add in for Molecular weight.
From: eestudent-ga on 14 Jul 2006 14:03 PDT
 
The website cannot be opened with Firefox. Try IE. I have never seen this before.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy