Process Monitoring Log

[dandy]

I have a continuous data entry log (example below) and i want a formula at the top to indicate whether data needs to be logged or not based on the values entered below. There has to be at least 25 data points collected.

I want to make it so that it says something like this in a formula.

1. There has to be at least 25 data points in the column (if not true, say "100% Inspection Required")
2. The data points have to be under the nominal value (<.004) (if not true, say "100% Inspection Required")
3. As soon as there is a data point GREATER than .004, i basically want to restart the count so that we have to get at least 25 more points in a row that are under .004 before it allows you to not inspect 100%.

Is this even possible?



Nominal Value: .004

Job #	Measured Value
	FORMULA
M513200-1	0.0030
M513200-2	0.0020
M513200-3	0.0030
M513200-4	0.0039
M513200-5	0.0027
M513200-6	0.0030
M513200-7	0.0021
M513200-8	0.0005
M513200-9	0.0008
M513200-10	0.0019
M513500-1	0.0023
M513500-2	0.0004
M513500-3	0.0004
M513500-4	0.0020
M513500-5	0.0024
M513500-6	0.0031
M513500-7	0.0019
M513500-8	0.0025
M513500-9	0.0002
M513500-10	0.0004
M513500-11	0.0017
M513500-12	0.0021
M513500-13	0.0003
M513500-14	0.0003
M513500-15	0.0003
M513500-16	0.0002
M513500-17	0.0030
M513500-18	0.0020
M513500-19	0.0030
M513500-20	0.0039
M513500-21	0.0027

<tbody>
</tbody>