Spreadsheet Tool for Dimensional Calculations

摘要

Spreadsheet-based tools for converting dimensional quantities from one set of dimensional units to another quickly and efficiently as well as correctly and automatically performing mathematical calculations using dimensional and dimensionless quantities are described. More particularly, the computer-based systems, methods and spreadsheet software perform mathematical calculations with both dimensional and dimensionless quantities, allowing extensive flexibility and customization so that both the user input and the computer output use the units that are most useful and convenient.

主权项

1. A non-transitory computer-readable medium having stored thereon computer-executable instructions which when executed by a computer perform a method for computing formulas involving dimensional quantities located in pairs of cells in a spreadsheet application workbook, the method comprising:
generating at least one pair of input cells in the spreadsheet application workbook comprising a first input cell containing a numeric value and a second input cell containing a dimensional unit of measure associated with the first cell value; generating an output pair of cells comprising a first output cell containing an original spreadsheet formula referencing the first input cells of the input cell pairs containing the numeric values but not the second input cells of the input cell pairs containing the dimensional units of measure associated with the first input cell values; receiving an indication to alter the formula in the first output cell containing the original spreadsheet formula; altering the formula in the first output cell of the output cell pair so that it references both cells in the input cell pairs and computes the original formula so that the result is either a dimensionally accurate and consistent result displayed in the pair of output cells, or an error message if a dimensionally accurate and consistent result cannot be computed; and electronically outputting the result in the output cell pair using an output device.