EquationsEquations are the backbone of the template. These formulas define the relationships between rows.
ComponentsAn 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.
SolvingpowerOne 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 OperationsAll equations follow powerOne's order of operations rules.
Spreadsheets v. TemplatesEquations 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+A3then 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+A3In advanced templates you can drop both the A4 and the equals (=) symbol. See Advanced Templates for more details.