## Excel question

## Excel question

(OP)

Hello -

I am importing a temperature program into excel. Imported will be set point (SP), temp internal (TI), temp external (TE), and time. I want to set up a template that will recognize when then TE settles out (i.e. 40 ± 0.1) and then record the temp from another row. Looking at the attachment, recognize A, and then record B. Does anyone know the equations that I should be looking into? Thank you.

I am importing a temperature program into excel. Imported will be set point (SP), temp internal (TI), temp external (TE), and time. I want to set up a template that will recognize when then TE settles out (i.e. 40 ± 0.1) and then record the temp from another row. Looking at the attachment, recognize A, and then record B. Does anyone know the equations that I should be looking into? Thank you.

## RE: Excel question

## RE: Excel question

## RE: Excel question

For a second? A minute? An hour? Forever? For all subsequent recorded data?

## RE: Excel question

## RE: Excel question

## CODE -->

## RE: Excel question

## RE: Excel question

So for cells below, in column E you could have expression in cell E5 something like

=AND(D5=40,ABS(D6-40)<0.1,ABS(D7-40)<0.1,SUM($E$4:E4)=0)*C5

The answer is found by summing all column E or looking for max in column E.

C D E F G H

4

5 187.75 39.99 0.00

6 187.83 39.99 0.00

7 187.92 39.99 0.00 Answer 188.17

8 188.00 39.99 0.00

9 188.08 39.99 0.00

10 188.17 40.00 188.17

11 188.25 39.99 0.00

12 188.33 40.00 0.00

13 188.42 40.00 0.00

14 188.50 40.00 0.00

15 188.58 39.99 0.00

16 188.67 40.00 0.00

17 188.75 40.00 0.00

## RE: Excel question