CONSTANTS

Information

We've added all kinds of constants to our Google Sheets Add-on, like:

  • physical constants
  • electromagnetic constants
  • atomic and nuclear constants
  • physico-chemical constants

This allows you to perform all the necessary calculations from within Google Sheets.

The digits in between brackets (see reference) are left out and sometimes the significance is reduced to stay within the 15 digits cell capacity. Very small values, like the Planck length, are best formatted in a scientific notation to make the decimals visible, but they are still accounted for when doing calculations.

List

CONSTANTS LIST

Reference

The constants were derived from this Wikipedia site:


Syntax (JsDocs text from script)

/**
 * Present the Planck length in m. Make sure to format in a scientific notation !!
 * @return constant
 * @customfunction
 */
function CONST_PLANCKLENGTH() {
  return 1.616229 * Math.pow(10, -35);
}