# Formulas

Formulas allow you to perform math functions on measure sheet items. In addition, you can reference the values of other cells by using Formula IDs. Eagleview and Hover placeholders can be used in Formulas to automatically pull in measurements.

To reference the value or quantity of another Measure Sheet Item you must first make up a Formula ID.

- In the Price Guide click the black drop-down menu on
**Active Columns**to expand. - Check off
**Formula ID**and**Formula**under Measure Sheet Items. - Close the
**Active Columns**menu. - Create a
**Formula ID**of your choice. In the example below we want to reference the value in Shingles. Type the word*shingles*into the Formula ID column of Shingles. - Enter the
**Formula ID**surrounded by square brackets**[**&**]**into the**Formula**of the Measure Sheet Item you wish to pull the value into. In this example we are pulling the quantity of Shingles into the quantity of Underlayment. Type*[shingles]*into the Formula column of Underlayment.

## List of Formula Functions

The numbers below under ‘Format/Syntax’ can be replaced with the Formula ID of a different Measure Sheet Item to pull in the value of that Measure Sheet Item. The below are examples to simply show the format of the command.

Function | Format/Syntax |
---|---|

Add | [1] + [2] |

Subtract | [2] – [1] |

Multiply | [1] * [2] |

Divide | [2] / [1] |

Raise (To Power) | [1] ** [2] |

Square Root | sqrt([2]) |

Round Up | ceiling([0]) |

Round Down | floor([0]) |

Average | average({[1], [2], [2], [3], [4], [7], [9]}) |

Sum | sum({[1], [2], [2], [3], [4], [7], [9]}) |

Count | count({[1], [2], [2], [3], [4], [7], [9]}) |

Min | min({[1], [2], [2], [3], [4], [7], [9]}) |

Max | max({[1], [2], [2], [3], [4], [7], [9]}) |

Random Number | randomn(10) |

## Examples

- In the
**Shingles**Measure Sheet Item the**EagleView Roof Area**is being pulled in in square feet and**divided**by**100**to calculate the number of squares. It is then**multiplied**by**1.10**in order to add 10% waste. Note: The**Shingles**item has a**Formula ID**of**SHINGLES**. - The
**15lbs Felt**item uses the SHINGLES**Formula ID**which is then**divided**by**4**to output the number of rolls. - The
**RoofRunner**item uses the SHINGLES**Formula ID**which is then**divided**by**10**to output the number of rolls. - The
**Install Labor**item adds the SHINGLES and RIDGESHINGLES**Formula IDs**,**divides**them by**3**and uses the**ceiling**command to round up.