US Patent No. 10,394,947

SPREADSHEET WITH UNIT BASED MATH


Patent No. 10,394,947
Issue Date August 27, 2019
Title Spreadsheet With Unit Based Math
Inventorship Terry M. Olkin, Niwot, CO (US)
Brian Sean Morris, Boulder, CO (US)
Assignee Workday, Inc., Pleasanton, CA (US)

Claim of US Patent No. 10,394,947

1. A system for performing units-based math for spreadsheet cell values comprising:a processor to:
host a spreadsheet document;
parse a formula containing a first measure, a first unit of measure, a second measure, a second unit of measure, and an operator, wherein the spreadsheet document includes the formula;
determine whether the first unit of measure, the second unit of measure, and the operator are compatible, comprising to:
determine whether the first unit of measure and the second unit of measure are comparable, comprising to:
determine whether each unit of measure is capable of being converted to the other unit of measure; and
in response to a determination that the each unit of measure is not capable of being converted to the other unit of measure:
 determine whether the operator is a multiplication operator; and
 in response to a determination that the operator is the multiplication operator, determine that the first unit of measure, the second unit of measure, and the operator are compatible;
in response to a determination that the first unit of measure, the second unit of measure, and the operator are compatible:
determine a resulting measure and a resulting unit of measure by applying the operator to the first measure, the first unit of measure, the second measure, and the second unit of measure, comprising to:
in response to a determination that the first unit of measure and the second unit of measure are not comparable and the operator is the multiplication operator, multiply the first unit of measure and the second unit of measure to obtain the resulting unit of measure, wherein the resulting unit of measure comprises a combination of the first unit of measure, the operator, and the second unit of measure, wherein the first unit of measure and the second unit of measure do not comprise a like unit of measure; and
associate the resulting measure with the resulting unit of measure.