{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["QDR","CAR","PrevAct","ContinImprove","Audit Log","ISO-QAM-QAP-WI Matrix"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"QDR","index":0,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["QDR Seq No.","Customer QDR No.","Company QDR No.","WO/Job No.","Project Mgr (Initials)","Issued (Date)","Response (Date)","QDR Review Mtg (Date)","Action/Comments (What Happened & Suggested Resolution)","Audit Review (Date)","Action Closed"]
["0001",null,"1376-0745",1376,"BDH","2012-02-17",null,null,"dimension misread, email sent on 2/17/12 to vendor, TR Manufacturing, asking to remake parts"]
["0002",null,"1442-2625",1442,"NS","2012-02-10"]
["0003",null,"1429-DE15",1429,"BDH","2012-04-13","2012-04-13",null,"USE PARTS \"AS IS\" PER IWE EMAIL",null,"X"]
["0004",null,"1519-GG02",1519,"BDH","2012-04-24","2012-04-24",null,"paint is chipping, we mask part during assy, is there something else we can do to prevent?"]
["0005",null,"1535-HC93",1535,"BDH","2012-04-25",null,null,"we will rework parts in-house, simply notified vendor of their incorrect part marking",null,"X"]
["0006",null,"0749-8798","0749","BDH","2012-04-24",null,null,"waiting for part samples, conductivity not a checkable issue"]
["0007",null,"1551-HW32",1551,"NS","2012-05-30"]
["0008",null,"1275-5398",1275,"SE","2012-06-15","2012-06-20",null,"welds are incorrect, vendor has picked up to rework, CAR sent to Mark 6/26/12"]
["0009",null,"1581-274131",1581,"BDH","2012-06-25","2012-06-25",null,"parts from new tech had radius on wrong end, new tech contacted via email, will send us new parts, qdr send to new tech on 6/25/12"]
["0010",null,"2113-0104",2113,"BDH","2013-10-28","2013-11-20",null,"New Tech produced parts with incorrect bend radius & cracks in the bend, they have issued a CIR and will return reworked parts by 12/2/13"]
["0011",null,"1047-3927",1047,"TLC (MTC)","2014-01-27","2014-01-27",null,"Contact Metal notified of QDR and cc'd copy of CAR 5TVD6201400001.",null,"X"]

{"sheet":"CAR","index":1,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[" CAR Seq #","IWE CAR#","DCMA/Customer CAR No.","From QDR# (REQ/DOC#)","Contract No.","RCN No.","WO/Job No.","Project Mgr (Initials)","Issued (Date)","Response (Date)","CAR Review Mtg (Date)","Notes/Comments","Closing Comments","Audit Review (Date)","Action Closed"]
["0001",null,"3NBK9-2012-0001","n/a","n/a","n/a","n/a","BDH","2012-02-10","2012-02-18",null,"CAR is in regards to gov't ISO audit",null,null,"X"]
["0002","0914-C516","S3605A20121033","SC04001342U282","SPM4A7-11-M-C516","SC0400-11-4866","0914","BDH","2012-02-03",null,null,"waiting for exhibit sample, 2nd request sample sent 4/17/12, sample rec'd 6/20/12, parts will be reworked and returned to purchaser, CAR written, final CAR pkg sent to Mark 6/26/12","closed on 4/20/12 per Mark Monroe email, reopened when rec'd parts on 6/20/12, Mark said to communicate w/customer",null,"X"]
["0003","1275-5398","3NBK9-2012-0003","3NBK920120018","SPM7M2-11-M-5398","n/a","1275","SE","2012-06-15",null,null,"Drawing 613993, REV \"J\" requires welds to be on 4 inch on center. Many welds are 5 or greater on center.  Vendor was notified of error, they picked up parts 6/20/12 to rework, CAR sent to Mark 6/26/12","closed on 7/19/12 per Mark Monroe email",null,"X"]
["0004","0711-1191",null,null,"SPM7M7-10-M-1191","N45415-10-0004","0711","BDH","2011-09-27",null,null,"cutout is improperly located (upside down)","12 replacement parts shipped 8/20/12",null,"X"]
["0005","0944-E400",null,"3NBK920120019","SPM4A7-11-M-E400",null,"0944","BDH","2012-08-09",null,null,"IWE sent CAR to Mark on 9/26/12"]
["0006","1181-5450","3NBK920130001",null,"SPM7MC-11-M-5450",null,"1181","L.S.","2012-10-04",null,null,"IWE sent CAR to Ron on 10/5/12, IWE QA will have final review of all IWE contracts before presented to the gov't","closed on 11/6/2012 per Ron E. email",null,"X"]
["0007","1349-7145","3NBK920130003",null,"SPM4A7-12-M-W807",null,"1349","BDH","2012-10-31","2012-11-08",null,"AQL does not match inspection qty size.  IWE has written response CAR (sent 11/8/12) and QA file updated to no longer auto fill AQL.","CLOSED PER 11/14/12 EMAIL FROM MARK MONROE",null,"X"]
["0008","1106-M567","3NBK920130005",null,"SPM4A7-11-M-M567",null,"1106","BDH (MC)","2013-03-19",null,null,"During QA review at Burton Metals it was discovered that an outdated procedure (BMF SOP #QP 103-3) was being used for MIL-DTL-5541 which skips step 10 of the process","CLOSED PER 4/22/13 EMAIL FROM MARK MONROE",null,"X"]
["0009",null,"5TVD620140001","QDR1047-3927","SPE4A7-13-M-3927",null,"1047","TLC (MTC)","2014-01-29","2014-01-29",null,"Drawing 68A450643, Insp Item #13, .220 +/-.010 was .200 on FAT unit. Inspect Data Sht added #17 to check for taper."]

{"sheet":"PrevAct","index":2,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["PA No. (PASeq)","Action Date","W.O.","Preventative Action (Summary)"]
["PA001","2012-03-01",null,"Added a Preventative Maintenance Schedule for all major equipment. Controlled and monitored by Shane, GM. (See PMS)"]

{"sheet":"ContinImprove","index":3,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["CI No.","Action Date","W.O.","Continuous Improvement Action (Summary)"]
["CI0001","2012-05-01",1189,"check Dibbs before job is complete to ensure that all mods, if any, have been addressed; email sent 5/1/12 to employees"]
["CI0002","2012-04-09",null,"check all parts to ensure that they have been made to print, clean & burr free, etc. per SEM quality review of our performance"]
["CI0003","2012-02-01",null,"Released ~QA Rel 20 (Job-WO) (NSN) to update Packaging Requirements Tab - Added Palletization standards definition"]
["CI0004","2012-02-08",null,"Released ~QA Rel 21 (Job-WO) (NSN) to added more flexability to QA Forms 015a, 015b and 002; on-line update"]
["CI0005","2012-04-25",null,"Released ~QA Rel 22 (Job-WO) (NSN) to revise Data Input Sheet to clarify input codes; on-line update"]
["CI0006","2012-05-18",null,"Released ~QA Rel 23 (Job-WO) (NSN) to correct hard code script errors, which caused pagination errors when printing Contract Review Sheet; on-line update"]
["CI0007","2012-06-10",null,"Released ~QA Rel 24 (Job-WO) (NSN) to add Pco email link for direct emailing. On-line file update & Email to all 06/15/12"]
["CI0008","2012-06-22",1275,"educate employees on proper weld symbol interpretation using the manual Symbols for Welding, AWS A2.4, loc'd in IWE library; see B. Hoheisel for further explanation if needed"]
["CI0009","2012-07-30",null,"ITAR Statement update for correspondence, RFQ & PO, and QuickBooks RFQ/PO Records."]
["CI0010","2012-08-10",null,"Released ~QA Rel 25 (Job-WO) (NSN) to revise Data Input Sheet to added FAT/Production statement & add RFID locations; on-line update"]
["CI0011","2012-08-17",null,"Released WI 10.0 for gage calibration and using the on-line Calibration Master Schedule Excel Program, will be added to employee training log"]
["CI0012","2012-10-25",null,"Released ~QA Rel 26 (Job-WO) (NSN) to revise coding to increase speed and internal calculation event updates; on-line update"]
["CI0013","2012-12-05",null,"Released ~(Blank) Manual RFQ-PO Rel 20 to revise 15CFR 700 Rating Clause; on-line update"]
["CI0014","2012-12-05",null,"Released ~QA Rel 28 (Job-WO) (NSN) to revise coding and add VECP Form; on-line update (Included Rel 27 updates)"]
["CI0015","2013-02-12",null,"Released ~QA Rel 29 (Job-WO) (NSN) added drop-downs for the contract block #5 DX & DO priority codes just after the block #6 Criticality Code, added button to access the DD1694 instructions & notes regarding the addition of a “D” or “W” in the DD1694 number ID"]
["CI0016","2013-04-17",null,"Released ~QA Rel 30 (Job-WO) (NSN) as an update for the first article sequencing change (no 9000 CLIN's)"]
["CI0017","2013-07-17",null,"updated our QA Data Record (Release 3.1) with the new DD1694"]
["CI0018","2013-10-30",null,"QMS Review/Update & issued QAM release C"]
["CI0019","2013-12-23",null,"Released ~QA Rel 34 (Job-WO) (NSN) covering most of the new FOB changes with new/revised item lists for I/A and FOB points."]
["CI0020","2014-01-28",null,"Updated ISO-QAM-QAP-WI Matrix, incorporated into IWE current Rel 10 Quality Action Log (QAL)----> Rel 10 replaced by QAL Rel 11"]

{"sheet":"Audit Log","index":4,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Audit No. (yySeq#)","Audit Date","Audit Area Code","Audit Summary","Action Required",null,"Audit Area Code","Action Code"]
["1201","2012-05-01","Management Specific","Work Instructions for major in-house procedures. Issued new WI's see QA Doc Folder for details.","Approved w/Change"]
[1202,"2012-06-01","Procedure, System","Gage calibration procedure. System incomplience, no action required.","Approved",null,"Management Specific","Approved"]
[1301,"2013-06-28","Document Control","Contract review audit of QAP 3.0 & WI 1.0.  Areas for improvement are proper placement of quality related items in the quality folder.","Approved",null,"Document Control","Approved w/Change"]
[1302,"2013-10-30","Processing, System","QAM-QMS Manual system documentation sync to actual contract cycle and documentation. Issued QAM Release C.","Approved w/Change",null,"Processing, System","CAR Issued"]
[null,null,null,null,null,null,"Procedure, Mfg","QDR Issued"]
[null,null,null,null,null,null,"Procedure, System","CI Initiated"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"-----------Last Line-------------"]

{"sheet":"ISO-QAM-QAP-WI Matrix","index":5,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
["ISO/Clause","ISO/Descriptive","QAM/Clause","REV","QAP","REV","WI","REV","FORMS/DOCUMENTS","REV"]
[]
["4.2.1","General","1.0","C","1.0","C"]
["4.2.2","Quality Manual","1.0 &2.0","C","1.0","C"]
["4.2.3","Control of Documents","4.2, 4.4, 4.6, 4.9","C","5.0","A"]
["4.2.4","Control of Records","4.2","C","5.0 / 16.0","A / C"]
[5.0999999999999996,"Management Responsibility & Commitment","1.0/2.0","C","1.0","C"]
[5.2,"Customer Focus","1.0/2.0","C","1.0","C"]
[5.3,"Quality Policy","1.0","C","1.0","C"]
["5.4.1","Planning - Quality Objective","2.0","C","2.0","B"]
["5.4.2","Quality management system planning","2.0","C","2.0","B"]
["5.5.1","Responsibility and authority","2.1","C","1.0/2.0","C/B"]
["5.5.2","Management representative","2.1","C","2.0","B"]
["5.5.3","Internal communications","3.1/4.10","C","1.0/2.0","C/B"]
[5.6,"Management Review","2.0/3.2","C","1.0","C"]
[6.1,"Provision of resources","3.2","C","2.0","B"]
["6.2.2","Competence, Training  and Awareness  ","3.0","C","18.0","C","4.0","A"]
[6.3,"Infrastructure","3.1","C"]
[6.4,"Work  Environment","4.7.4","C"]
[7.1,"Planning of Product Realization","4.11","C","3.0","C","1.0","B","QA Master File & QA009, QA010, QA013","35/A/A/A"]
["7.2.1","Determination of Requirements Related to the Product","4.10, 4.11","C","3.0","C","1.0","B","QA Master File & QA009, QA010, QA013","35/A/A/A"]
["7.2.2","Review of requirements related to the product","4.10, 4.11","C","3.0","C","1.0","B","QA013, QA015a & b","A/A/A"]
["7.2.3","Customer communication","4.15","C","2.0","B","1.0","B","QA017","A"]
[7.3,"Design and development/ planning","N/A",null,"4.0 (In Edit)","B"]
["7.4.1","Purchasing Process","4.3 and this log","C /Rel 12","6.0 (In Edit)","C","8.0","A","ASL/SQAM & QA016","N/C & B/A"]
["7.4.3","Verification of Purchased Product","4.3","C","12.0 (In Edit)","B","8.0","A","ASL, QA015a & b","N/C & A"]
["7.5.1","Control of Production & Service Provision  ","4.4, 4.6","C","9.0 (In Edit) / 19.0 (In Edit)","B/B","1.0","B","QA015a & b","A"]
["7.5.3","Identification & traceability","4.7.5","C","8.0 (In Edit)","B","1.0","B","QA013, QA015a & b","A/A"]
["7.5.4","Customer Property","4.3","C","7.0 (In Edit)","B"]
["7.5.5","Preservation of product","4.11","C","15.0 (In Edit)","B","1.0","B","QA011, QA012","A/A"]
[7.6,"Control of Monitoring & Measuring Equipment","4.6, 4.7","C","11.0 (In Edit)","B","10.0","A","Calibration Software (Was QA007 & QA008)","A"]
[8.1,"Measurement, Analysis and Improvement - General","4.4, 4.6, 4.7, 4.15","C","11.0 (In Edit)","B","10.0","A","QA013, QA015a & b","A/A/A"]
["8.2.1","Customer satisfaction","4.15","C","22.0","C",null,null,"QA017","A"]
["8.2.2","Internal Audit","4.1 + this log","C /Rel 12","14.0/17.0","C/C","9.0","A","QA001, QA002","A/A"]
["8.2.3","Monitoring and measurement of processes","4.4.3","C","9.0 (In Edit)","B",null,null,"QA015a & b","A"]
["8.2.4","Monitoring & Measurement of Product","4.4","C","3.0/10.0/11.0 (In Edit)","B","1.0","B","QA015a & b, QA012, ME001","A/A/A"]
[8.3000000000000007,"Control of Nonconforming Product","4.5","C","13.0","C","13.1 MRB If authorized","A","QA005, QA001, QA015a & b","A/A/A"]
[8.4,"Analysis of data","4.13","C","20.0 (In Edit)","B",null,null,"QA111","N/C"]
["8.5.1","Continual Improvement","1.0/4.15","C","22.0","C",null,null,"Quality Action Log (QAL)","Rel 11"]
["8.5.2","Corrective action","4.5","C","14.0 and this log.","C /Rel 12",null,null,"QA015a & b, QA001","A/A"]
["8.5.3","Preventive action","4.5","C","14.0 and this log.","C /Rel 12",null,null,"QA015a & b, QA001","A/A"]