Using Spreadsheet Formulas

This section describes how to take advantage of working in a spreadsheet editor while creating a test sequence

Using Spreadsheet Formulas to Enhance Test Sequences

Since the creation of test sequences in FunTEST is in a spreadsheet editor you can take advantage of using regular spreadsheet formulas to enhance the test sequence capabilities

Use Cases

Creating Pass/Fail Criteria for a test step

Most common use case is to use spreadsheet formulas to create pass and fail criteria

Is Result within Limit?

The example below uses the following formula to verify if the result is within specified limits

=IF(AND(L69>=J69,L69<=K69),0,1)

You can create any custom pass/fail criteria by using spreadsheet formulas.

Always structure your formulas so if step passes display 0 and otherwise display 1

The pass/fail criteria you can create are only limited by spreadsheet formula capabilities

Post-processing Return value for result

Often times the raw result from the measurement step is not in the desired format. We can use spreadsheet formulas to convert return value to our desired format in the result cell

The example below uses the following formula to take absolute value from the return value

=ABS(VALUE(O86))

Create conditions for step execution

You can also use spreadsheet formulas to create conditions for step execution.

For example, you can make step execution dependent on the result of the previous step by using a formula in the exec column.

Below you can see that by using formula

=IF(O14="0",1,0)

we can make 3 test steps only executed when the DUT is not present (return value = 0). If the return value is 1 steps are skipped and the sequence keeps executing

Test sequence when DUT is present

Test sequence when DUT is not present

Creating condition for command parameter

The same way you can change the exec column values with spreadsheet formulas, you can do the same for command's parameters.

For example, based on all the results from a test sequence, I want to display a message to the operator with the result i.e. Pass or Fail.

Here is how you can implement it using the following formula in the #status parameter cell at the end of the test sequence:

="'Power-Up':panel=1:color="&IF(SUM(G25:G30)=0,"green","red")

Test Sequence Example

If all the results pass the sum is 0 and the panel color is green otherwise it's red. The rest of the formula are default parameters for #status command