Researchers often struggle with complex calculations on their data, dealing with time-consuming and error-prone methods. Scispot Labsheets provides a user-friendly solution, streamlining the process and making math in the lab easier and error-free.
Now, let's explore how to perform complex calculations in Scispot Labsheets:
Step 1: Create a new property
Open your Labsheet and scroll to the far right end of the heading row. Click on the '+' icon in this box to create a new column.
Step 2: Add a Formula into the desired column for executing the calculation.
Enter the column name and set the field type to NUMBER.
Writing the formula is the key step in customizing your data analysis. Begin with an equal sign: =, use the formula command in rounded parentheses: ( ), and reference the column name in square brackets: [ ].
Special Note for Exponential Values:
If your data involves exponential values, the function READ_SCIENTIFIC becomes a valuable tool. It helps read exponential values and computes the formula accordingly, adding versatility to your calculations.
Formula Verification:
Ensuring accurate formula syntax is crucial. A file at the end of this article provides a quick reference for users, confirming that their formulas are error-free.
Edit or Delete Options:
Scispot Labsheets understands the need for flexibility. Users can easily edit or delete added properties with just a click, allowing for real-time adjustments as needed.
Run Jupyter scripts for multi-cell calculations.
For intricate calculations involving multiple cells, utilize Jupyter script executables tailored to your specific operation.
Step 3: Save your modifications, input data into your Labsheet, and watch as all intricate calculations are automated.
Save your modifications and go back to your Labsheet. Input data by selecting 'Add new'. Observe the effectiveness of the recently incorporated column with the formula, displaying computed values dynamically according to the provided formula.