When exporting asynchronous data to Excel, the data will be exported with the Dynamic acquisition rate. In case the rate of the asynchronous channel is really slow that means that it will be really hard to observe the Values of the Asynchronous data.
To properly order and place the Asynchronous data one by another with the correct time base and sample value the following workaround can be used in the Excel program.
Example 1:
In the following example, the asynchronous data with the rate of 2Hz and our Dynamic acquisition rate is 4Hz was exported to Excel format.
We want to rewrite the values from both columns in a separate line, so we would not have any empty spaces.
We can simply say, if the CELL IS NOT EMPTY, copy the value from the wanted column to another column.
To copy the values from column A, we use the following formula.
=INDEX(A:A, SMALL(IF(B:B<>"", MATCH(ROW(A:A), ROW(A:A)), ""),ROWS($G$1:G2)))
To copy the values from column B we use the following formula.
=INDEX(B:B, SMALL(IF(B:B<>"", MATCH(ROW(A:A), ROW(A:A)), ""),ROWS($G$1:G2)))
Please notice that the formula is calculating with the Arrays so when you enter the formula in the empty cell you need to press CTR+Shift+Enter, for the formula to properly calculate.
We get the following result:
Example: How to copy values from a different column
If we look at the formula, we can see that the first input value corresponds to the copied value. If we have values in the other columns as well, we need to change that value
Example 3: How to define search column
To determine the column that defines which cells to use or which cells are not empty, we adjust the condition in the IF statement.
