Excel spreadsheet - Atomic mass to frequency converter.

Here's an Excel 2010 spreadsheet that may help in converting (calculating) atomic mass of chemical element or chemical compound to its resonant frequency.
File: Atomic_Mass_Freqs.xlsm

The spreadsheet contains four sheets:

1. Main_Form = main interface, where we enter data. Rows (lines) contain names of chem.elements, and we need to enter only the number of atoms in the corresponding row.

An element has several rows dedicated to it when its isotopes have significant isotopic composition (abundance), i.e. each such isotope has its own row. In such cases, the first row in such group is for the most abundant isotope of that element. (Of course, you will enter number of atoms in only one of those rows, usually in the first row.)

Here is the field for the "Frequency Limit", where you enter a number (in Hz) which will be the upper limit for the displayed subharmonics of resonant frequency. That will be the maximal frequency displayed in the results.

2. Frequencies = the results of calculation are displayed here. After all numbers of atoms have been entered, recalculate the spreadsheet (graphical button [Recalculate] ) and switch to this sheet to copy desired subharmonic number.

3. User_Defined_AM = use this sheet to calculate resonant frequency of an atomic mass (weight) of your own choice (an arbitrary atomic mass).

4. Data = this is the core of this spreadsheet. It keeps table of elements (isotopic data), data used in calculations. You would access (use) this sheet only in case when you want to change isotopic data for an element, or change custom Conversion Factor.

The rest three sheets are backup.

More info about this spreadsheet and usage is in the attached file:

(The same info is also in the Main_Form sheet -> scroll down a bit.)

Save the file to your preferred (easy to find) location. It doesn't have to be Spooky directory.

Note about Conversion Factor:
Spreadsheet uses calculated 'Conversion Factor', based on the latest available data for the Planck constant (from Jan 2016) and for the Avogadro constant (Avogadro number) (from Dec 2015).

It also contains another Conversion Factor (we call it 'Custom Conversion Factor'). This one comes from:
(it's a 2014 CODATA recommended value).

You can choose which one to use. (More about that in file 'Atomic_Mass_Freqs.txt'.)

Note about macro commands:
This spreadsheet has several Excel macro commands built-in.

Depending on the Excel's security settings, Excel itself may block loading of macros contained in this file (or may issue a warning, asking for permission to load macros).

Therefore, enable macros in Excel (allow macros to load & run). Since macros are not enabled by default, when you click one of the buttons Excel issues a warning and prevents macro to run. It usually advises that macro cannot be found or was blocked. Just click on something like "Enable Content" (it's usually on the yellow banner appearing at the top).

Will reload Excel file later. At this moment "The server encountered an internal error or misconfiguration and was unable to complete your request." (Attaching a file works with PM, but not here.)


For more details, please check the link:

Have more questions? Submit a request


Please sign in to leave a comment.