Square Feet function for google sheets

square-feet-function.js

/**
* @param {string} dimensions Ex. 12"3'x10"7'
* @customfunction
*/
function SQUAREFT(dimensions) {
  var parts = dimensions.split("x")
  var width = parseFeet(parts[0])
  var height = parseFeet(parts[1])
  return width * height
}

/**
 * Given a ft and inches string return feet as integer
 */
function parseFeet(ftInches) {
  var FEET = "'"
  var INCHES = '"'
  var FTIN = /^(\d+')?(\d+")?$/
  if (!FTIN.test(ftInches)){
    throw new Error("invalid measurement")
  }
  var matches = ftInches.match(FTIN)
  var feet = matches[1] || (0 + FEET)
  feet = parseInt(feet.substring(0, feet.length - 1))
  var inches = matches[2] || (0 + INCHES)
  inches = parseInt(inches.substring(0, inches.length - 1))
  return (feet * 12 + inches) / 12
}