SBS - The Best Value in QMS software

Strange test result form - CFG-1003 form

C

Caine Lu

#1
Hi guys ,

I have a supplier who is using thee CFG-1003 form and he told me he met a very strange problem.

looked at the attachedment .
item 2 and item 3 - the data should fall into the range but the result is NOT ok ... is there a specific reason for that ?

any help is appreciated !

thanks
 

Attachments

Elsmar Forum Sponsor
F

Fencick

#2
Re: Strange test result form

Howdy Caine,

I cannot attach files (or am not bright enough this morning to figure out how).

If you'll paste this into o11: =IF(C11="basic","X",IF(MAX(I11:N11)>(F11),"",IF(MIN(I11:N11)<(E11),"","X")))

and this into p11: =IF(C11="basic","",IF(MAX(I11:N11)>(F11),"X",IF(MIN(I11:N11)<(E11),"X","")))

Then drag copy them for the complete columns, it will correct the logic flaw. You'll also have to fill column E with the actual minimum spceifications.

Final note, item #10, you'll have to remove the "N"'s and leave results in numeric format for the formula to be able to work.

There may be a better way, but this will work.

Fen
 
F

Fencick

#4
Re: Strange test result form

Good morning again,

I must have taken the short bus in to work today. I had read the instructions for posting attachments but failed to see the rather large green 'Reply" button. I'd been using the quick reply button all along. Call me a noob. Thanks for help me out :)

Anyhow, please see attached.
 

Attachments

Kales Veggie

People: The Vital Few
#5
Hi guys ,

I have a supplier who is using thee CFG-1003 form and he told me he met a very strange problem.

looked at the attachedment .
item 2 and item 3 - the data should fall into the range but the result is NOT ok ... is there a specific reason for that ?

any help is appreciated !

thanks
Hi,

The form only works correctly with numbers, not degrees or "N".

The cells you highlighted should have just numbers such as 90 for the angle nominal. For angles you have to convert the minutes to a decimal notation (30 ' is 0.5 degrees).

Remove the "N" from the force values and replace 30-50N with 40 with a spec. limits of 20 and 50 (no "N")

I would not change the formulaes in the form.
 
Thread starter Similar threads Forum Replies Date
Marc The Strange & Curious Tale of the Last True Hermit Coffee Break and Water Cooler Discussions 0
P Strange Gage R&R results for a Caliper (Tolerance Method) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
AnaMariaVR2 Mars-Inspired Art, Commissioned by NASA, Births Strange Sci-Fi Photos Coffee Break and Water Cooler Discussions 1
S Strange PT Ratio on an Excel spreadsheet for variable GRR ANOVA Method Excel .xls Spreadsheet Templates and Tools 2
Claes Gefvenberg Those strange forum dwellers... Coffee Break and Water Cooler Discussions 2
Ajit Basrur Strange "Manufactured in China with US and China Materials" Coffee Break and Water Cooler Discussions 12
Marc Five Strange Materials including Liquids you can Walk on Coffee Break and Water Cooler Discussions 3
Wes Bucey GM/Renault/Nissan? Strange bedfellows? World News 4
L Strange facts about states Coffee Break and Water Cooler Discussions 26
L Strange letter from Underwriters Laboratories (UL) Promising Change Misc. Quality Assurance and Business Systems Related Topics 10
R Cost per test tool/formula Oil and Gas Industry Standards and Regulations 1
R Cost per test tool/formula Oil and Gas Industry Standards and Regulations 1
A R chart from ANOVA gage R&R test Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 11
K Ground Bond Test for Class I Medical Electrical Equipment - calibration problems IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
P Burst Test Acceptability Criteria ISO 13485:2016 - Medical Device Quality Management Systems 2
A 60601-1 clause 8.11.3.6 Test Clarification IEC 60601 - Medical Electrical Equipment Safety Standards Series 0
E Test report to certify compliance with IEC 62304 IEC 62304 - Medical Device Software Life Cycle Processes 3
E Tensile test machine, tinius olsen 602 Manufacturing and Related Processes 1
M Test failure Root cause not found Customer Complaints 10
Moumen H Variations between ASTM A29 Standard for steel bars and Mill test certificates specs Manufacturing and Related Processes 1
D Tip test 10° -> 5° IEC 60601 - Medical Electrical Equipment Safety Standards Series 1
M Sponsor name presented in the test report EU Medical Device Regulations 4
M Packing Validation & Accelerated Aging Test ISO 13485:2016 - Medical Device Quality Management Systems 2
S OEM full range calibrations vs Validation special test points Medical Device and FDA Regulations and Standards News 0
C IEC 60601 - 8.8.3 Dielectric Strength test. 4kv being applied to the ground conductor?! IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
S Shelf Life Test for IFU and Implant Card Other Medical Device Related Standards 1
S Mechanical Test Under FDA Freedom of Information Act Medical Device and FDA Regulations and Standards News 5
S Critical characteristic on manufacturing operations test procedure Inspection, Prints (Drawings), Testing, Sampling and Related Topics 0
R IEC 60601-1 Clause 15.3.2, Push test IEC 60601 - Medical Electrical Equipment Safety Standards Series 0
S Knee Implant (Femoral -Cobalt chrome)-Sub chronic toxicity test (ISO 10993-11)choice of root Medical Device and FDA Regulations and Standards News 2
A Defining a lower ESD test level in IEC 60601 safety test IEC 60601 - Medical Electrical Equipment Safety Standards Series 5
N Is there a need for clinical test of Class IIa products (for MDR)? EU Medical Device Regulations 2
A Is calibration of test weight required General Measurement Device and Calibration Topics 4
S Non parametric test for semi-quantitative data. Statistical Analysis Tools, Techniques and SPC 5
Ed Panek Disaster Recovery Test IT (Information Technology) Service Management 3
A How much does a complete biocompatibility test package cost? Other ISO and International Standards and European Regulations 1
M Is it normal / sufficient to have only the IEC 60601-1-2 test report without indicating IEC 60601-1? IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
Z Is Op Amp Common-Mode Rejection Ratio (CMRR) test applicable to battery operated devices? Other Medical Device Related Standards 0
E When to perform accelerated aging studies and transport test(OQ or PQ) Qualification and Validation (including 21 CFR Part 11) 4
U Does *anyone* know a lab that will test to EN 455-4 Medical Gloves shelf life determination? EU Medical Device Regulations 1
A Test requirements for marketing in US when RATED values are not of US IEC 60601 - Medical Electrical Equipment Safety Standards Series 5
H Secondary Circuits, Voltage Test and Clearance/Creepage IEC 60601 - Medical Electrical Equipment Safety Standards Series 0
S Fogging test as per DIN 75201(50ug/g ) VDA Standards - Germany's Automotive Standards 3
R HV Test of HF Surgical Unit IEC 60601 - Medical Electrical Equipment Safety Standards Series 1
R IEC 60601-1 - 11.1.3 e) Test criteria - Temperature Measurements IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
E 60950-1 resistance to abnormal heat test Various Other Specifications, Standards, and related Requirements 0
S User evaluation for self monitoring blood glucose test systems US Food and Drug Administration (FDA) 4
E MSA for Push and Pull test Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
Z IEC 60601-2-25; Frequency response test Medical Device and FDA Regulations and Standards News 1
J Confusing on Harmonic Emissions/Voltage Fluctuations/Flicker test for CISPR 11 Class A Equipment IEC 60601 - Medical Electrical Equipment Safety Standards Series 2

Similar threads

Top Bottom