Equations

Equations are the backbone of the template. These formulas define the relationships between rows.

Components

An equation can be made up of multiple components, as in this example:

Area = sin(Width/45) * Length
  • Variables: defined in the Getting Started section, examples from the equation above include Area, Width and Length.
  • Constants: values that do not change. In the example above, 45 is a constant. Enter constants in the same format as set in the Settings app. Use the same decimal separator, period or comma, as you do in the calculator. (The thousand's separator, also as it would appear in the calculator, is optional.)
  • Operators: mathematical symbols such as plus, minus, times and divide. In the example above, both multiply (*) and divide (/) are operators.
  • Functions: allows for more advanced mathematical capabilities, which are built into the calculator. In the example above, sine (sin) is a function.
Note that spaces and returns are ignored. Feel free to use spaces and returns to make your equations more read-able.

Solving

powerOne makes it possible to calculate any variable within the equation. For instance, if you enter Width and Length, Area will be calculated. If you enter Area and Length, Width will be calculated.

If the value to be calculated is not isolated to the left or right of the expression then powerOne's solver will be used to iteratively calculate the result. It is faster and more accurate to not require the solver. In the example A = B + C, B and C require the solver while A does not. The same is true for the example B + C = A. In the example A + B = C + D the solver will always be used.

Order of Operations

All equations follow powerOne's order of operations rules.

Spreadsheets v. Templates

Equations in powerOne are very similar to equations in a spreadsheet. In a spreadsheet a cell can be defined as an equation. For instance if cell A4 was assigned the following equation:

=A1+A2+A3

then cell A4 would equal the sum of A1, A2 and A3. The equals (=) symbol is only there to indicate to the spreadsheet that this is a formula (and not text). In simple templates you have to include the original cell as well, like so:

A4=A1+A2+A3

In advanced templates you can drop both the A4 and the equals (=) symbol. See Advanced Templates for more details.

HP Solve v. Templates

Hewlett Packard's solver, called HP Solve, works similarly to powerOne with a few, minor structural changes.

Examples

See the Simple Templates section for examples.