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.
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.
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).
To enter results directly into the Worksheet, follow these steps:
- Identify the Product / Formula (column) to which the test is being performed.
- 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.
- 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.
- Report results (if necessary).
- That's it, you're done!
- 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.
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:
- Data spanning multiple trials.
- Data specific to a particular lot or batch
- Delegation of work to technician, analytical group or shared service center
- 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