Inline Results Entry in the Worksheet

Welcome to the Worksheet! The Worksheet is packed with capabilities so you can manage and organize your data more effectively than ever before. 

Albert Worksheet Results Grid

Save time and clicks with the ability to view and enter result data directly in your formulating experience in the Results Grid.

For more information on the Results grid, please go to this help article.

Inline Results Entry

Inline Results Entry - Data Structure

In the Results grid, the parent row displays the task name and encompasses all parameter group details. Click the icon next to the task name to see more actions. Click Expand Summary to quickly see the parameter groups, parameters, and values of the row.

Screenshot 2023-10-18 at 3.20.52 PM.png

View the data templates results (or data columns) and intervals by expanding the parent row. Any data input in the Results Grid stays anchored to these attributes.

Screenshot 2023-10-18 at 3.23.00 PM.png

How to Seamlessly add Data Inline

Eliminate the middle step - input data directly into your Worksheet and replicate the structure of a Property Task (Inventory, Parameter groups, and Data Templates).

Screenshot 2023-10-18 at 3.21.42 PM.png

To enter results directly into the Worksheet, follow these steps:

  1. Identify the Product / Formula (column) to which the test is being performed.
  2. Find the proper Data Template in the Results Grid to which the data is to be entered.
    • If the Data Template required is not populated in the Results Grid, create a Property Task to set the desired structure with the proper Parameter Groups and Data Template. This auto-generates Results Rows in the Worksheet for inline data entry.
  3. Run the test(s) required, and enter the results directly inline the Worksheet by clicking on the corresponding cell next to the appropriate data column from the Data Template (shows up as a row in the Results grid) and typing in the value(s). The Parameter Groups, Parameters, Data Template, and Inventory item (Product / Formula) will be automatically linked.
  4. Report results (if necessary).
  5. That's it, you're done!

Key Notes:

  • If a Property Task has already been completed for the Product / Formula for a certain Data Template, the Task results will automatically sync to the Worksheet.
    • The Worksheet will not write to the Data Template if a Task has not been completed.
  • Interval data can also be directly entered into the Worksheet and will appear in the same structure as in a Property Task.
  • Set targets for your inline values by clicking on the specific data column row that the target is to be set on and adding the target value.
    Screenshot 2023-10-23 at 4.49.14 PM.png

Coming Soon: add result rows directly from the Worksheet without creating a Property Task. 

Directly enter data inline following the same structure that keeps your data clean and organized—inventory, parameter groups, and data templates.


When to still rely on Task Creation

While the results grid augments your data-entry process, certain situations warrant task creation:

  1. Data spanning multiple trials.
  2. Data specific to a particular lot or batch
  3. Delegation of work to technician, analytical group or shared service center
  4. When data is captured directly from a piece of equipment to a Property Task via Albert Sync.


Coming Soon: Albert aims to further simplify trial and lot-specific data inputs directly from the worksheet—no task required

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request



Please sign in to leave a comment.