We've added all kinds of constants to our Google Sheets Add-on, like:
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.
The constants were derived from this Wikipedia site:
/**
* 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);
}