Welcome to the Worksheet! The Worksheet is packed with capabilities so you can manage and organize your data more effectively than ever before.
The goal of the Apps Grid is to allow future applications to be built and to allow you to bring in more complex calculations that you can manage out of this section. The apps grid is great for adding notes or adding in the custom rows to give you more information on your products!
Four different row types are supported by the Apps Grid:
- Tag rows
- Pricing rows
- Predecessor rows
- Blank rows
Tag Rows pull in any tags associated with your formulations.
Add new Tags to your Grid directly from the Grid. Hover over the Pencil on the right side of the Tags cell and click to edit the tags for the specific Product / Formula. From there, you can select any currently existing tag using the search bar or the scroll functionality and clicking the checkbox to add. The search will filter as you type when searching for a specific tag and will automatically update with the new tags. You can also add any new tag by typing in the search bar the name of the tag you want to add, then selecting the "+ Add" at the bottom of the pop-up. The new tag will automatically be added and active. Click off the pop-up to close the add tags section. To deselect a tag, simply click on the Pencil to edit the tags, and uncheck the box next to the tag no longer needed. You can also edit / view tags by simply clicking on an existing tag which will open the Tags pop-up.
(TIP: Tags are an important filter method, so using appropriate tags in this section can make the Worksheet more organized.)
Pricing rows calculate the total price of a designed Product or Formula based on pricing information of each raw material.
Hover over dropdown caret to select a different viewpoint (i.e. average, minimum, or maximum). All values within cells update automatically. You can also view total prices by location from this same dropdown.
When you select a pricing cell, all of the pricing details for the raw materials will automatically populate next to the raw material quantity. To get rid of this view, simply select the pricing cell again.
If there is a warning icon, it means one of the pricing values is zero. To see which pricing value is Zero, select the pricing value to expose all of the associated prices for each raw material. The raw material with the zero next to it is the one to change.
Predecessor rows allow you to track the parent Product / Formula was designed from.
Cell in predecessor has a selectable dropdown icon that appears when you hover over it. It will have a list for options for different predecessors, cell will update with new predecessor selected.
(TIP: Predecessor rows allow for easy tracking from which specific Products / Formulas were designed.)
Blank Rows - Adding and Deleting
Blank rows in the Apps Grid allow you to take notes on your Products / Formulas.
There are two ways to add blank rows to the Apps Grid.
- Click the + sign next to the Apps header in the Worksheet, and select Add a Blank Row. This adds a blank row in the first position of the Apps grid.
- Click the three dots (...) next to any name cell in the Apps grid and select Add a Blank Row. This adds a blank row inline to the selected row.
(TIP: Another row is automatically added until you leave a row empty or click off of the grid!)
You can delete blank rows from the Apps Grid if accidentally created or if no longer needed. You can do this by clicking the three dots (...) next to the blank row you want to delete, and selecting Remove Row..0.