top of page
Search

The new FizziQ spreadsheet

The FizziQ Spreadsheet is an integrated tool within the app that allows users to enter, manipulate, and visualize numerical data. Designed specifically for educational settings, it combines ease of use with powerful features for scientific data analysis.


Spreadsheet Interface

The FizziQ spreadsheet offers an intuitive interface divided into several areas:

  • Column headers: Identified by letters (A, B, C...) or custom names

  • Row numbers: Sequential numbering of rows (1, 2, 3...)

  • Cells: The intersection of columns and rows where data is stored

  • Toolbar: Options to switch between table view and graph view


Basic Operations

Adding Data

  • Tap a cell to select it

  • Enter the desired value or formula

  • Press Enter or tap another cell to confirm

Editing Data

  • Tap the cell to modify to open the editor

  • Edit the content

  • Confirm by pressing Enter

Adding Rows and Columns

  • Add a row: Tap the "+" button below the last row

  • Add a column: Scroll to the right until the "+" button appears after the last column


Spreadsheet Navigation

Horizontal Navigation

  • Swipe left or right to scroll through columns

  • Use the navigation arrows at the bottom to move between columns

Vertical Navigation

  • Scroll up or down to view more rows


Data Manipulation

Column Management

Tap a column header to access options:

  • Rename column: Set a custom label

  • Add sequential indices: Auto-fill the column with numbers

  • Set decimals: Choose number of displayed decimals (0–4)

  • Delete column: Remove the entire column

Row Management

Tap a row number to access options:

  • Move up/down: Reorder rows

  • Add row: Insert a new row after the current one

  • Duplicate row: Copy the selected row

  • Delete row: Remove the selected row

Cells

Double-tap a cell to access options:

  • Copy to entire column: Duplicate the value/formula to the whole column

  • Copy formula: Copy only the formula to the clipboard


Formulas and Functions

Formula Syntax

Formulas always begin with an equal sign (=), followed by the expression to evaluate.

Column References

Use column labels to reference values:Example: =A+B adds the values of columns A and B for the current row

Math Operators

  • Addition: +

  • Subtraction: -

  • Multiplication: *

  • Division: /

  • Exponentiation: ^


Built-In Functions

Math Functions

  • sin(colX), cos(colX), tan(colX), arcsin(a), arccos(a), arctan(a) – Trigonometry

  • e^colX, ln(colX) – Exponential and logarithm

  • sqrt(colX), nrt(colY,colX) – Square root and n-th root

Statistical Functions

  • sum() – Calculates the sum of previous values in the column

  • average() – Calculates the average of previous values

  • stddev() – Calculates the standard deviation of previous values

Analysis Functions

  • DERIVE(colY, colX) – Computes the derivative of Y with respect to X at the current rowExample: =DERIVE(B, A)

  • DERIVE2(colY, colX) – Computes the second derivative of Y with respect to XExample: =DERIVE2(B, A)

Navigation Functions

  • PREC(colX) – Retrieves the value from the previous row in the specified columnExample: =PREC(A) + 1 adds 1 to the previous value in column A

  • NEXT(colX) – Retrieves the value from the next row in the specified column

Examples of Complex Formulas

  • =A*2 + B^2 – Multiplies A by 2 and adds the square of B

  • =SUM() / (ROW-1) – Averages previous values in the column

  • =(B - PREC(B)) / (A - PREC(A)) – Calculates rate of change between two rows


Graph Visualization

Accessing Graph Mode

  • Click the "Graph" button in the toolbar

  • Configure graph settings in the dialog

Graph Configuration

  • X-axis: Choose a column or use row index

  • Y-axis: Choose up to three columns

  • Interpolation: Select from several types of interpolation to show trends:

    • Linear

    • Quadratic

    • Exponential

    • Logarithmic

    • Sinusoidal

Graph Interaction

  • Zoom on Y-axis: Use zoom in/out/reset buttons

  • Horizontal navigation: Use the bottom slider to adjust X range

  • Trackball/crosshair: Enable or disable to see exact values


Tips and Tricks

Effective Use

  • Name your columns clearly: Use meaningful names for easier formula references

  • Use decimals wisely: Choose decimal precision based on your needs

  • Start with simple data: Make sure your basic data is accurate before adding complex formulas

  • Save regularly: Changes are saved automatically when you leave the spreadsheet


Troubleshooting

  • #N/A: Value not available or formula error

  • #ERR: Invalid column reference

  • #ERR: Syntax error in formula

  • #ERR: Not enough points to calculate derivative or interpolation


Usage Examples

Example 1: Moving Average

  • Column A: Raw data

  • Column B: Moving average over 2 points=(A + PREC(A)) / 2

Example 2: Instantaneous Speed

  • Column A: Time (seconds)

  • Column B: Position (meters)

  • Column C: Instantaneous speed=DERIVE(B, A)

Example 3: Compound Interest

  • Column A: Year

  • Column B: Capital=PREC(B) * 1.05 (for a 5% interest rate)


Conclusion

This guide covers the essential features of the FizziQ spreadsheet. For specific questions or advanced features, feel free to consult the full app documentation.

 
 
 

Comments

bottom of page