I inherited a database that is used to create certificates of conformance. the basic layout is as follows:
lot | product | date of manufacture | specific measurement | standard dev | test range
or:
Lot1233 | acme holes | 7/12/1975 | 3.14 | .43 | 3-3.3
I am looking for a conditional format that would fill the specific measure if the value was out of spec.
This is easy enough with version 2007. However, what do you when the specs are to be determined (TBD) or simply not performed on that particular product (NA)?
Also, specifications may be one sided, that is greater than a certain number, say 7, or smaller than, say 21.
so the possible specs will include: a range (3.1-3.2), a min only (>3), a max only (<21), not determined (TBD), or not tested (NA).
I would like to test for TBD and NA conditions and if not present then compair the measurement against the spec.
I am not sure how to do this as Excel thinks the measurement is a number and the min/max are text values separated by a dash "-".
Any ideas?
lot | product | date of manufacture | specific measurement | standard dev | test range
or:
Lot1233 | acme holes | 7/12/1975 | 3.14 | .43 | 3-3.3
I am looking for a conditional format that would fill the specific measure if the value was out of spec.
This is easy enough with version 2007. However, what do you when the specs are to be determined (TBD) or simply not performed on that particular product (NA)?
Also, specifications may be one sided, that is greater than a certain number, say 7, or smaller than, say 21.
so the possible specs will include: a range (3.1-3.2), a min only (>3), a max only (<21), not determined (TBD), or not tested (NA).
I would like to test for TBD and NA conditions and if not present then compair the measurement against the spec.
I am not sure how to do this as Excel thinks the measurement is a number and the min/max are text values separated by a dash "-".
Any ideas?
Last edited: