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

[TABLE="class: grid, width: 237"]
<tbody>[TR]
[TD]Job #[/TD]
[TD]Measured Value[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]FORMULA
[/TD]
[/TR]
[TR]
[TD]M513200-1[/TD]
[TD]0.0030[/TD]
[/TR]
[TR]
[TD]M513200-2[/TD]
[TD]0.0020[/TD]
[/TR]
[TR]
[TD]M513200-3[/TD]
[TD]0.0030[/TD]
[/TR]
[TR]
[TD]M513200-4[/TD]
[TD]0.0039[/TD]
[/TR]
[TR]
[TD]M513200-5[/TD]
[TD]0.0027[/TD]
[/TR]
[TR]
[TD]M513200-6[/TD]
[TD]0.0030[/TD]
[/TR]
[TR]
[TD]M513200-7[/TD]
[TD]0.0021[/TD]
[/TR]
[TR]
[TD]M513200-8[/TD]
[TD]0.0005[/TD]
[/TR]
[TR]
[TD]M513200-9[/TD]
[TD]0.0008[/TD]
[/TR]
[TR]
[TD]M513200-10[/TD]
[TD]0.0019[/TD]
[/TR]
[TR]
[TD]M513500-1[/TD]
[TD]0.0023[/TD]
[/TR]
[TR]
[TD]M513500-2[/TD]
[TD]0.0004[/TD]
[/TR]
[TR]
[TD]M513500-3[/TD]
[TD]0.0004[/TD]
[/TR]
[TR]
[TD]M513500-4[/TD]
[TD]0.0020[/TD]
[/TR]
[TR]
[TD]M513500-5[/TD]
[TD]0.0024[/TD]
[/TR]
[TR]
[TD]M513500-6[/TD]
[TD]0.0031[/TD]
[/TR]
[TR]
[TD]M513500-7[/TD]
[TD]0.0019[/TD]
[/TR]
[TR]
[TD]M513500-8[/TD]
[TD]0.0025[/TD]
[/TR]
[TR]
[TD]M513500-9[/TD]
[TD]0.0002[/TD]
[/TR]
[TR]
[TD]M513500-10[/TD]
[TD]0.0004[/TD]
[/TR]
[TR]
[TD]M513500-11[/TD]
[TD]0.0017[/TD]
[/TR]
[TR]
[TD]M513500-12[/TD]
[TD]0.0021[/TD]
[/TR]
[TR]
[TD]M513500-13[/TD]
[TD]0.0003[/TD]
[/TR]
[TR]
[TD]M513500-14[/TD]
[TD]0.0003[/TD]
[/TR]
[TR]
[TD]M513500-15[/TD]
[TD]0.0003[/TD]
[/TR]
[TR]
[TD]M513500-16[/TD]
[TD]0.0002[/TD]
[/TR]
[TR]
[TD]M513500-17[/TD]
[TD]0.0030[/TD]
[/TR]
[TR]
[TD]M513500-18[/TD]
[TD]0.0020[/TD]
[/TR]
[TR]
[TD]M513500-19[/TD]
[TD]0.0030[/TD]
[/TR]
[TR]
[TD]M513500-20[/TD]
[TD]0.0039[/TD]
[/TR]
[TR]
[TD]M513500-21[/TD]
[TD]0.0027[/TD]
[/TR]
</tbody>[/TABLE]